From mboxrd@z Thu Jan  1 00:00:00 1970
From: Mike Gauland <mikelygee@no8wireless.co.nz>
Subject: Re: Org-mode as a metalanguage: calling SQL "functions"
Date: Mon, 1 Apr 2013 20:41:01 +0000 (UTC)
Message-ID: <loom.20130401T223733-920@post.gmane.org>
References: <CAFChFyhX2TKTt0vAc8vSyFXabAgUaBM0Muru4hZEtYGQrm2SHg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:46861)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UMlXk-0006HQ-5v
	for emacs-orgmode@gnu.org; Mon, 01 Apr 2013 16:41:29 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UMlXh-0008V2-LF
	for emacs-orgmode@gnu.org; Mon, 01 Apr 2013 16:41:28 -0400
Received: from plane.gmane.org ([80.91.229.3]:40619)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UMlXh-0008Ur-EV
	for emacs-orgmode@gnu.org; Mon, 01 Apr 2013 16:41:25 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UMlY2-0005JN-Fy
	for emacs-orgmode@gnu.org; Mon, 01 Apr 2013 22:41:47 +0200
Received: from 218-101-54-25.trimble.co.nz ([218.101.54.25])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 01 Apr 2013 22:41:46 +0200
Received: from mikelygee by 218-101-54-25.trimble.co.nz with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 01 Apr 2013 22:41:46 +0200
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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