[postmodern-devel] s-sql insert-into problem

[Jens Teich]

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