Kaushal Modi <kaushal.m...@gmail.com> writes: > Hi Dushyant, > > The folks following the org mailing list might be able to help you out on > this. So I am forwarding this > email there. > > I haven't tried recreating this as I do not use sqlite. > > But when you say that in the case where you use the default :results sqlite > doesn't work, what doesn't > work? Do you get an error? > > ---------- Forwarded message --------- > From: Dushyant Juneja <juneja.dushy...@gmail.com> > Date: Wed, Sep 14, 2016 at 10:08 AM > Subject: bug with org-babel/sqlite? > To: help-gnu-em...@gnu.org <help-gnu-em...@gnu.org> > > Hi, > > Looks like I stumbled upon a bug with org-babel and sqlite. I have the > following in my org file. PFA the bug description (bug.org). The essence is > that sqlite queries work with :results verbatim, but not otherwise. Any > ideas on how to get past this? > > This is with emacs 24.5.2, RHEL6. > > Dushyant > -- > > Kaushal Modi > >
Changing the CSV file slightly gets rid of the problem: ,---- | #+BEGIN_SRC csv :tangle sample1.csv | Year,Make,Model,Description,Price | 1997,Ford,E350,"ac, abs, moon",3000.00 | 1999,Chevy,"Venture ""Extended Edition""","",4900.00 | 1999,Chevy,"Venture ""Extended Edition, Very Large""",,5000.00 | 1996,Jeep,Grand Cherokee,"MUST SELL! air, moon roof, loaded",4799.00 | #+END_SRC `---- ^ The CSV file had a newline ^here. If you eliminate the newline, things work as they should. Whether that's a bug in ob-sqlite or sqlite itself, I have no idea. -- Nick