[postmodern-devel] Query generation

[Ralf Mattes]

On Wed, 2007-06-27 at 14:29 -0400, Osei Poku wrote:
> Hi,
> 
> I want to generate the following query:
> 
> "UPDATE table1 SET col1 = NULL, col2 = NULL"
> 
> from the following list: ("col1" "col2")
> 
> my attempt is:
> 
> (sql
>    (append
>       '(:update :table1 :set)
>       (loop for a in '("col1" "col2")
>             collect a collect :NULL)))
> 
> but that apparently doesnt work.  this can probably be attributed to
> my newness to lisp.
> 
> Any ideas?

'postmodern:sql' is a macro, not a function and hence will not evaluate
its argument. When your code really looks like above you could fix it
like this:

(sql #.(append
       '(:update :table1 :set)
        (loop for a in '("col1" "col2")
            collect a collect :NULL)))


HTH Ralf Mattes


 
>  thanks
>