Do you mean decimal 10 or octal 10? Decimal 10 is newline (which is what I'd expect), octal 10 is backspace. Pete
On Mon, Apr 2, 2012 at 12:05 PM, Bob Sneidar <b...@twft.com> wrote: > I just checked to see what revDataFromQuery uses for a row delimiter by > default, if you do not provide one. It returns ascii 10, the backspace > character! Very odd. Must be an HTML thingummy. > > I then specified comma and cr as the column and row delimiters like so: > > put revDataFromQuery(comma,cr,theConnID,"select * from events") & cr > into theSQLData > put revDataFromQuery(comma,cr,theConnID,"select * from clients") & cr > after theSQLData > > This produced NO extra line that I could see. If you still get an extra > line using this method, I suspect you have a blank record in your table. > > Bob > > > On Apr 2, 2012, at 10:57 AM, Martin Koob 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@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
