[on-rev]Line endings for a db query

[Bob Sneidar]

Reference my post. I think he may have a blank row in his database. 

Bob


On Apr 2, 2012, at 12:12 PM, Pete wrote:

> Hi Martin,
> That's strange. I just tried the following test:
> 
> put revDataFromQuery(,,gDBID,"SELECT * FROM t1) into tVar
> put return & revDataFromQuery(,,gDBID,"SELECT * FROM t1) after tVar
> 
> tVar looked just like it should after the above, no blank lines.
> 
> Are you using the default rowdelim character for revDataFromQuery?  What
> platform are you on?  My test was done on a Mac.
> 
> Pete
> 
> On Mon, Apr 2, 2012 at 10:57 AM, Martin Koob <mkoob at rogers.com> wrote:
> 
>> Hi Peter
>> 
>> Thanks, I just tried your suggestion.
>> 
>> That still inserts blank lines into the variable that I have to filter out
>> later.
>> 
>> It seems the revDataFromQuery does not insert an end of line character
>> after
>> the last record and
>> it seems that the end of line character that is used to separate lines in
>> the variable is not the same as the return or LF constants in LiveCode.
>> 
>> Martin
>> 
>> --
>> View this message in context:
>> http://runtime-revolution.278305.n4.nabble.com/on-rev-Line-endings-for-a-db-query-tp4526068p4526757.html
>> Sent from the Revolution - User mailing list archive at Nabble.com.
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> 
> 
> 
> -- 
> Pete
> Molly's Revenge <http://www.mollysrevenge.com>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode