Hi All, Is there any way that we can export the data to CSV format to the disk. Thanks, Joanne
----- Original Message ---- From: Kees Nuyt <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, December 18, 2007 8:11:08 AM Subject: Re: [sqlite] Re: Error in SQLite's CSV output On Wed, 19 Dec 2007 00:14:42 +1100, T&B <[EMAIL PROTECTED]> wrote: >> I think I've discovered yet another bug in the CSV output using the >> sqlite3 command line tool. >> >> Here's a sample of the new bug: >> >> .mode csv >> select 'a=1,234', 'b=5'; >> >> gives: >> a=1,234,b=5 >> >> but should give: >> "a=1,234",b=5 > >Since no replies, I'll assume this is a bug. I've reported it as: >http://www.sqlite.org/cvstrac/tktview?tn=2850 > >CSV seems to have quite a history of bugs in SQLite :-/ > >Tom Just for the record: There is a fix in CSV, which will be included in the next version. Related Check-ins: 2007-Dec-18 15:41 Check-in [4638] : In the CLI, quote strings that contain the separator character. Ticket #2850. (By drh) -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping