27 Jun
2007
27 Jun
'07
6:29 p.m.
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