From mboxrd@z Thu Jan 1 00:00:00 1970 From: tsd@tsdye.com (Thomas S. Dye) Subject: orgtbl-to-sqlinsert Date: Sun, 02 Feb 2014 10:09:10 -1000 Message-ID: Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:41241) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WA3M6-0000PZ-DD for emacs-orgmode@gnu.org; Sun, 02 Feb 2014 15:09:32 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WA3M0-0007EL-7z for emacs-orgmode@gnu.org; Sun, 02 Feb 2014 15:09:26 -0500 Received: from oproxy16-pub.mail.unifiedlayer.com ([69.89.22.201]:54992) by eggs.gnu.org with smtp (Exim 4.71) (envelope-from ) id 1WA3M0-0007EH-0M for emacs-orgmode@gnu.org; Sun, 02 Feb 2014 15:09:20 -0500 Received: from [98.155.255.145] (port=51294 helo=poto.local) by box472.bluehost.com with esmtpsa (UNKNOWN:CAMELLIA128-SHA:128) (Exim 4.80) (envelope-from ) id 1WA3Lu-0002iz-9Z for emacs-orgmode@gnu.org; Sun, 02 Feb 2014 13:09:14 -0700 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: Org-mode Aloha all, I'm expecting column names in the "foo( )" part of the INSERT statement. I've done my best to understand http://orgmode.org/worg/org-tutorials/multitarget-tables.org.html but appear to have failed. Can someone help? *** Experiment with orgtbl-sqlinsert #+name: test-table | one | two | |-----+--------| | 1 | Buckle | | 2 | Shoe | | 3 | Open | | 4 | Door | #+name: test-bed #+header: :var x=test-table #+begin_src emacs-lisp (require 'orgtbl-sqlinsert) (orgtbl-to-sqlinsert x '(:sqlname "foo" :fmt (1 "%s"))) #+end_src #+results: test-bed : BEGIN TRANSACTION; : INSERT INTO foo( ) VALUES ( 1 , 'Buckle' ); : INSERT INTO foo( ) VALUES ( 2 , 'Shoe' ); : INSERT INTO foo( ) VALUES ( 3 , 'Open' ); : INSERT INTO foo( ) VALUES ( 4 , 'Door' ); : COMMIT; All the best, Tom -- T.S. Dye & Colleagues, Archaeologists 735 Bishop St, Suite 315, Honolulu, HI 96813 Tel: 808-529-0866, Fax: 808-529-0884 http://www.tsdye.com