[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Chicken-users] sqlite3 issues
From: |
Alejandro Forero Cuervo |
Subject: |
[Chicken-users] sqlite3 issues |
Date: |
Tue, 7 Nov 2006 22:38:00 -0500 |
User-agent: |
Mutt/1.5.11 |
I'm trying to get svnwiki to use sqlite3 instead of sqlite. However,
I've stumbled into a problem.
I created a DB. I can use my sqlite3 binary to execute queries
against it.
However, I'm failing to get the sqlite3:for-each-row function from
Chicken's sqlite3 egg to execute for some queries:
#;1> (use sqlite3)
; loading /opt/chicken-2.5/lib/chicken/1/sqlite3.so ...
; loading /opt/chicken-2.5/lib/chicken/1/tinyclos-base.so ...
; loading /opt/chicken-2.5/lib/chicken/1/synch-support.so ...
#;2> (define db (sqlite3:open "deps.db"))
#;3> db
#<sqlite3:database>
#;4> (sqlite3:for-each-row (constantly #f) db "SELECT * FROM links;")
#;5> (sqlite3:for-each-row (constantly #f) db "DELECT FROM links;")
Error: (sqlite3:prepare) unrecognized token: ""
#<sqlite3:database>
"DELECT FROM links;"
Call history:
<eval> (sqlite3:for-each-row (constantly #f) db "DELECT
FROM links;")
<eval> (constantly #f) <--
#;5>
Am I misunderstanding something or is this a bug in the sqlite3 egg?
Thank you for your work in making wrappers around sqlite3, Thomas! I
certainly benefit from them. :-)
Alejo.
http://azul.freaks-unidos.net/