From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: using orgtbl-sqlinsert Date: Wed, 25 Sep 2013 00:00:23 +0200 Message-ID: <2C4DFA4F-3950-42D8-BFC5-D588078C3DB7@gmail.com> References: <87obbyut4n.fsf@ericabrahamsen.net> Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\)) Content-Type: multipart/signed; boundary="Apple-Mail=_48418E9C-C482-405E-82CF-FDE0DEDD8970"; protocol="application/pgp-signature"; micalg=pgp-sha1 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51785) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VOaeo-0003K1-ER for emacs-orgmode@gnu.org; Tue, 24 Sep 2013 18:00:39 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VOaei-0001zp-Ry for emacs-orgmode@gnu.org; Tue, 24 Sep 2013 18:00:34 -0400 Received: from mail-wg0-x232.google.com ([2a00:1450:400c:c00::232]:42855) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VOaei-0001zf-Lg for emacs-orgmode@gnu.org; Tue, 24 Sep 2013 18:00:28 -0400 Received: by mail-wg0-f50.google.com with SMTP id f12so5278801wgh.17 for ; Tue, 24 Sep 2013 15:00:27 -0700 (PDT) In-Reply-To: <87obbyut4n.fsf@ericabrahamsen.net> 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: Eric Abrahamsen Cc: emacs-orgmode@gnu.org --Apple-Mail=_48418E9C-C482-405E-82CF-FDE0DEDD8970 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Eric, do you have orgtbl-to-sqlite defined? What does it look like? Do you have the BEGIN RECEIVE and END RECEIVE lines in the buffer? Are you working in a buffer that is not in Org-mode? Do you have = orgtbl-mode turned on? Regards - Carsten On 26.5.2013, at 08:56, Eric Abrahamsen wrote: > 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. >=20 > 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: >=20 > #+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 = Publishing | > | =E5=AE=9A=E4=BB=B7=E6=80=BB=E9=87=91=E9=A2=9D | Aggregate = Retail Price | > (etc) >=20 > 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). >=20 > Does this still work? Or is it still possible to jimmy = orgtbl-sqlinsert > to either insert directly, or create a block of INSERT statements? >=20 > Thanks! >=20 > Footnotes: >=20 > [fn:1] http://orgmode.org/worg/org-tutorials/multitarget-tables.html >=20 >=20 --Apple-Mail=_48418E9C-C482-405E-82CF-FDE0DEDD8970 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- iQEcBAEBAgAGBQJSQgt3AAoJEO+gg/nAZuwMfWEIAMAcK8aI9NGzH5RSkQ9ve4sz 3PpiY+nGf6vUXSUeaKUfC3GLU1FY+iUscjbc4tsmywz1/VUC6z+PhpT8eibGibWJ n9BmkljS58s4yYvnOxG10s6+z4SWTBbKR/JJLVKmgIYnCS7MXsdO2lgYF+jmmZbk He3d2yIzwIIFoHBgEACKZWPePzF+sEbwE1tNeUkT/uiNABr4Ej/3sWwJyyfD2AcD 8zgda0xaipfQnHL1rE/TbR/upJswxVM1SBP01JjLxtzU2C8U6rPH641FQRcnN8YA O+4zALF77l4/wr/RD6pWRmmFl8OZnCUQSnhNMaZ7fGfUjEUA/9cV5fJDVjU2RXY= =odQo -----END PGP SIGNATURE----- --Apple-Mail=_48418E9C-C482-405E-82CF-FDE0DEDD8970--