Some starter guidance?
Peter Stirling <[email protected]>
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <1256056747.4223.14889.camel@peter-desktop> |
Hi,
I'm writing a web-app in lisp as my first project, because it has
reasonable complexity, but is something that I've done before (in
Java/python/php). I have
Since I'm not sure how it works[1], and already can write my own sql, I
wanted to avoid using the [SQL] (at least to start with).
However, looking through the documentation it seems that there is noThis
prepared-statement style variable-substitution? (Hunting backwards
through the mailing list archives there was [2] from April where he was
told just to use the sql syntax stuff).
In the interest of getting something working for the time being, I've
been making query strings with (format ...), but I've been getting a
(memory corruption?) error message for one innocuous looking query:
* (clsql:query "update client_details set date_of_birth = '1981-05-07'")
debugger invoked on a SB-SYS:MEMORY-FAULT-ERROR in thread #<THREAD
"initial thread" RUNNING {1002669D11}>:
Unhandled memory fault at #x60.
Type HELP for debugger help, or (SB-EXT:QUIT) to exit from SBCL.
restarts (invokable by number or by possibly-abbreviated name):
0: [ABORT] Exit debugger, returning to top level.
(SB-SYS:MEMORY-FAULT-ERROR)
I've tried 'make clean', to no effect.
I got clsql from clbuild, and sbcl is SBCL 1.0.18.debian on ubuntu,
mysql is 5.0.75-0ubuntu10.2 (also the ubuntu package).
Any help would be nice.
;; ========================================================
[1] I tried to make a macro for locally enabling the syntax:
(defmacro with-sql-syntax (&body body)
`(progn
(clsql:locally-enable-sql-reader-syntax)
,@body
(clsql:locally-disable-sql-reader-syntax)))
but it doesn't seem to do anything (i.e. compile errors), neither where
I was intending to use it (wrapping (clsql:select inside functions), nor
as wrapped around top-level defuns.
[2] http://lists.b9.com/pipermail/clsql/2009-April/001698.html