[postmodern-devel] Query generation

27 Jun 2007

      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?

thanks

-- 
Osei Poku
PhD Student, ECE
Carnegie Mellon University