[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] Fwd: bug with org-babel/sqlite?

From: Nick Dokos
Subject: Re: [O] Fwd: bug with org-babel/sqlite?
Date: Wed, 14 Sep 2016 17:16:47 -0400
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1.50 (gnu/linux)

Kaushal Modi <address@hidden> 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 <address@hidden>
> Date: Wed, Sep 14, 2016 at 10:08 AM
> Subject: bug with org-babel/sqlite?
> To: address@hidden <address@hidden>
> 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
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.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]