14 Apr
2008
14 Apr
'08
12:59 p.m.
I have a tablename as string, a list of fieldnames as strings and a list of values known only at runtime all.
Tried the following. What is going wrong?
HB> (sql (append (list :insert-into (intern "table") :set) (loop for k in '("field1" "field2" "field3") for v in '(4 5 6) append (list (intern k) v))))
Error: Value (:INSERT-INTO |table| :SET |field1| 4 |field2| 5 |field3| 6) can not be converted to an SQL literal. [Condition of type SIMPLE-ERROR]
Jens