From: Nick Dokos <ndokos@gmail.com>
To: emacs-orgmode@gnu.org
Subject: Re: Fwd: bug with org-babel/sqlite?
Date: Wed, 14 Sep 2016 17:16:47 -0400 [thread overview]
Message-ID: <87zinaxjuo.fsf@gmail.com> (raw)
In-Reply-To: CAFyQvY3OPxTaNa9Jyr73RSsALQLV5KfoCK=c6==Fbvs1Dz=QrQ@mail.gmail.com
Kaushal Modi <kaushal.modi@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.dushyant@gmail.com>
> Date: Wed, Sep 14, 2016 at 10:08 AM
> Subject: bug with org-babel/sqlite?
> To: help-gnu-emacs@gnu.org <help-gnu-emacs@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
next prev parent reply other threads:[~2016-09-14 21:17 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
[not found] <CAJkb0UMZmHe=DJ565W-V-rSkJTgFi6B5RtcVfWK3O7oOXc8gCg@mail.gmail.com>
2016-09-14 19:00 ` Fwd: bug with org-babel/sqlite? Kaushal Modi
2016-09-14 21:16 ` Nick Dokos [this message]
[not found] ` <CAFyQvY34G=TSsQy-=hmB3ot-2CvpuwD66me6LemvfZaxr_8fjQ@mail.gmail.com>
2016-09-15 6:14 ` Dushyant Juneja
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87zinaxjuo.fsf@gmail.com \
--to=ndokos@gmail.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).