From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: David Pirotte Newsgroups: gmane.lisp.guile.user Subject: Re: crash in guile-sqlite3 Date: Fri, 27 Apr 2012 20:59:53 -0300 Message-ID: <20120427205953.3d000ac1@rascar> References: <20120427160028.7bff8d19@rascar> NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Trace: dough.gmane.org 1335571218 4929 80.91.229.3 (28 Apr 2012 00:00:18 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Sat, 28 Apr 2012 00:00:18 +0000 (UTC) Cc: guile-user@gnu.org To: Sunjoong Lee Original-X-From: guile-user-bounces+guile-user=m.gmane.org@gnu.org Sat Apr 28 02:00:17 2012 Return-path: Envelope-to: guile-user@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1SNv5B-0000di-L2 for guile-user@m.gmane.org; Sat, 28 Apr 2012 02:00:13 +0200 Original-Received: from localhost ([::1]:55683 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SNv5A-0007RT-PV for guile-user@m.gmane.org; Fri, 27 Apr 2012 20:00:12 -0400 Original-Received: from eggs.gnu.org ([208.118.235.92]:44824) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SNv56-0007Pe-4S for guile-user@gnu.org; Fri, 27 Apr 2012 20:00:09 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1SNv54-0002Ox-Eu for guile-user@gnu.org; Fri, 27 Apr 2012 20:00:07 -0400 Original-Received: from maximusconfessor.all2all.org ([62.58.108.13]:38346) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1SNv54-0002NI-8T for guile-user@gnu.org; Fri, 27 Apr 2012 20:00:06 -0400 Original-Received: from localhost (unknown [192.168.0.2]) by maximusconfessor.all2all.org (Postfix) with ESMTP id 8B874A04C141; Sat, 28 Apr 2012 02:00:04 +0200 (CEST) Original-Received: from maximusconfessor.all2all.org ([192.168.0.1]) by localhost (maximusconfessor.all2all.org [192.168.0.2]) (amavisd-new, port 10024) with ESMTP id cUUZ3dJNQP62; Sat, 28 Apr 2012 01:35:30 +0200 (CEST) Original-Received: from rascar (unknown [139.82.89.157]) by maximusconfessor.all2all.org (Postfix) with ESMTPSA id 015A5A04C143; Sat, 28 Apr 2012 01:59:55 +0200 (CEST) In-Reply-To: X-Mailer: Claws Mail 3.8.0 (GTK+ 2.24.10; i486-pc-linux-gnu) X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6 (newer, 3) X-Received-From: 62.58.108.13 X-BeenThere: guile-user@gnu.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: General Guile related discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guile-user-bounces+guile-user=m.gmane.org@gnu.org Original-Sender: guile-user-bounces+guile-user=m.gmane.org@gnu.org Xref: news.gmane.org gmane.lisp.guile.user:9413 Archived-At: hello, > ... > (stmt (sqlite-prepare db "INSERT INTO foos(name) VALUES(?);"))) i'd rather bind the statment in scheme _anyway_ if i was you. david ;; -- (use-modules (sqlite3)) (define db (sqlite-open "ex0.db")) (define (sqlite/command db command) (let ((stmt (sqlite-prepare db command))) (sqlite-step stmt) (sqlite-finalize stmt) (if #f #f))) (define (my-insert new-name) (sqlite/command db (format #f "INSERT INTO foos(name) VALUES('~A')" new-name))) (sqlite/command db "DROP TABLE IF EXISTS foos;") (sqlite/command db "CREATE TABLE foos(dbid INTEGER PRIMARY KEY, name TEXT);") (for-each (lambda (name) (my-insert name)) '("foo-1" "foo-2" "foo-3"))