* SQLite in 7.01h?
@ 2010-09-18 18:32 Bill Harris
2010-09-19 3:23 ` Bill Harris
0 siblings, 1 reply; 3+ messages in thread
From: Bill Harris @ 2010-09-18 18:32 UTC (permalink / raw)
To: emacs-orgmode
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'm probably just missing it, but I didn't see anything in the manual,
the FAQ, the mailing list, or from a Google search.
I rediscovered org-mode this week; I had used much earlier versions some
years ago, but org-babel really attracted my attention.
I've gotten v 7.01h to work on Debian Stable and XP for R, elisp, and
sh, but I can't figure out how to make it work for SQLite. I did enable
SQLite as one of the languages, but, when I execute the following
section, I get "No org-babel-execute function for Sqlite!":
#+BEGIN_SRC Sqlite
sqlite3 sqlite/db.sqlite
select * from table;
#+END_SRC
(The org-mode file is in a directory with a subdirectory called sqlite,
and the database is there.)
I did a similar thing for R, and it works:
#+BEGIN_SRC R
3 + 4
#+END_SRC
#+results:
: 7
I'm running this test with GNU Emacs 22.2.1 on Debian Stable; I'm
running sqlite3 version 3.5.9.
What am I missing? Can you give me an example SQLite source code block
that works?
Thanks,
Bill
- --
Bill Harris http://makingsense.facilitatedsystems.com/
Facilitated Systems Everett, WA 98208 USA
http://www.facilitatedsystems.com/ phone: +1 425 374-1845
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkyVBacACgkQ3J3HaQTDvd8avQCfVQ4gMOXMjEHRqrETLJG+pmrt
OW4AnR1Kbh7wHEV+qZuSJOfeKGUCSMv+
=DPVV
-----END PGP SIGNATURE-----
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: SQLite in 7.01h?
2010-09-18 18:32 SQLite in 7.01h? Bill Harris
@ 2010-09-19 3:23 ` Bill Harris
2010-12-04 17:50 ` Michael Gauland
0 siblings, 1 reply; 3+ messages in thread
From: Bill Harris @ 2010-09-19 3:23 UTC (permalink / raw)
To: emacs-orgmode
Bill Harris <bill_harris@facilitatedsystems.com> writes:
> I've gotten v 7.01h to work on Debian Stable and XP for R, elisp, and
> sh, but I can't figure out how to make it work for SQLite. I did enable
> SQLite as one of the languages, but, when I execute the following
> section, I get "No org-babel-execute function for Sqlite!":
>
> #+BEGIN_SRC Sqlite
> sqlite3 sqlite/db.sqlite
> select * from table;
> #+END_SRC
I found a workaround
#+begin_src sh :results replace
sqlite3 sqlite/db.sqlite 'select * from table;'
#+end_src
but it would surely be nice to be able to use the SQLite connection
directly.
Bill
--
Bill Harris http://makingsense.facilitatedsystems.com/
Facilitated Systems Everett, WA 98208 USA
http://www.facilitatedsystems.com/ phone: +1 425 374-1845
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: SQLite in 7.01h?
2010-09-19 3:23 ` Bill Harris
@ 2010-12-04 17:50 ` Michael Gauland
0 siblings, 0 replies; 3+ messages in thread
From: Michael Gauland @ 2010-12-04 17:50 UTC (permalink / raw)
To: emacs-orgmode
I believe all you need to do is change 'Sqlite' to 'sqlite' (all lower case) in
the +BEGIN_SRC line.
--Mike
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2010-12-04 17:51 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2010-09-18 18:32 SQLite in 7.01h? Bill Harris
2010-09-19 3:23 ` Bill Harris
2010-12-04 17:50 ` Michael Gauland
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).