Whoops! My bad yes it's dec 12 newline. I just assumed in a list of that nature on a web site the first column would be the one the majority of people care about. :-)
Bob On Apr 2, 2012, at 12:16 PM, Pete wrote: > 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 _______________________________________________ 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