From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Abrahamsen Subject: using orgtbl-sqlinsert Date: Sun, 26 May 2013 14:56:08 +0800 Message-ID: <87ehcm1ah6.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:53577) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UihVx-0000D4-99 for emacs-orgmode@gnu.org; Sat, 01 Jun 2013 04:50:18 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UihVw-0004pU-8h for emacs-orgmode@gnu.org; Sat, 01 Jun 2013 04:50:17 -0400 Received: from plane.gmane.org ([80.91.229.3]:55632) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UihVw-0004pK-2n for emacs-orgmode@gnu.org; Sat, 01 Jun 2013 04:50:16 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1UihVt-0006yG-GN for emacs-orgmode@gnu.org; Sat, 01 Jun 2013 10:50:13 +0200 Received: from 114.250.133.24 ([114.250.133.24]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 01 Jun 2013 10:50:13 +0200 Received: from eric by 114.250.133.24 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 01 Jun 2013 10:50:13 +0200 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 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 | |------------------+------------------------------------| | 音像制品出版 | A/V Publishing | | 定价总金额 | 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