Re: [O] Org-mode as a metalanguage: calling SQL "functions"

[Mike Gauland]

Gary Oberbrunner <garyo <at> oberbrunner.com> writes:
> Is this supposed to work?
> -- Gary

I'm not sure how it's /supposed/ to work, either, but this example works for a
sqlite database I've been playing with:

  #+NAME: artist
  #+BEGIN_SRC sqlite :db the_sound_A-Z.sql :var song_title=""
  select artist from playlist where title=="$song_title";
  #+END_SRC

  #+CALL: artist(song_title="Pressure")

  #+RESULTS: artist(song_title="Pressure")
  : Billy Joel

Note the need for double quotes around $song_title in the SRC block.

I'm using the latest from git, and emacs 23.2.1 on Debian.

Hope that helps.

Kind Regards,
Mike Gauland