From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Abrahamsen Subject: Re: using orgtbl-sqlinsert Date: Sun, 02 Jun 2013 13:25:21 +0800 Message-ID: <87y5atcce6.fsf@ericabrahamsen.net> References: <87obbyut4n.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35436) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uj0nI-0003u1-IV for emacs-orgmode@gnu.org; Sun, 02 Jun 2013 01:25:31 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Uj0nE-0006Rv-Cw for emacs-orgmode@gnu.org; Sun, 02 Jun 2013 01:25:28 -0400 Received: from mail-pb0-x232.google.com ([2607:f8b0:400e:c01::232]:52696) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uj0nE-0006Rg-6g for emacs-orgmode@gnu.org; Sun, 02 Jun 2013 01:25:24 -0400 Received: by mail-pb0-f50.google.com with SMTP id wy17so4141314pbc.23 for ; Sat, 01 Jun 2013 22:25:22 -0700 (PDT) Received: from localhost ([114.252.248.94]) by mx.google.com with ESMTPSA id lq4sm57264928pab.19.2013.06.01.22.25.20 for (version=TLSv1.2 cipher=RC4-SHA bits=128/128); Sat, 01 Jun 2013 22:25:21 -0700 (PDT) In-Reply-To: <87obbyut4n.fsf@ericabrahamsen.net> (Eric Abrahamsen's message of "Sun, 26 May 2013 14:56:08 +0800") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 Eric Abrahamsen writes: A very quiet "bump", to see if anyone knows how to handle this... > I've got a table I'm trying to insert into a sqlite database. I've been > looking at orgtbl-sqlinsert and this page[fn:1], but I suspect all that > is out of date. I haven't seen anyone talking about #+ORGTBL: keywords, > or things like "#+BEGIN RECEIVE ORGTBL exsql" in the past year or so. > > Do those still work? I can't for the life of me get it to do anything. > I've got a sqlite database called "market.sqlite" in the same directory > as a file containing this: > > #+TBLNAME: terms > #+ORGTBL: SEND market.sqlite orgtbl-to-sqlinsert :sqlname "terms" > | Chinese | English | > |------------------+------------------------------------| > | =E9=9F=B3=E5=83=8F=E5=88=B6=E5=93=81=E5=87=BA=E7=89=88 | A/V Publis= hing | > | =E5=AE=9A=E4=BB=B7=E6=80=BB=E9=87=91=E9=A2=9D | Aggregate Retail = Price | > (etc) > > I've tried C-c C-c on that header, calling > `org-babel-execute-src-block', waving my fingers at it, and cursing > loudly, one of which usually works. But I get no error, no insertion > into the database, and no results block with INSERT statements (I tried > making a #+BEGIN RECEIVE ORGTBL marketdb.sqlite block as noted on worg). > > Does this still work? Or is it still possible to jimmy orgtbl-sqlinsert > to either insert directly, or create a block of INSERT statements? > > Thanks! > > Footnotes: > > [fn:1] http://orgmode.org/worg/org-tutorials/multitarget-tables.html