[postmodern-devel] sql-compile

[Stas Boukarev]

"Haris" <fbogdanovic at xnet.hr> writes:

> What am I doing wrong here:
>
> (query (sql-compile `(:update 'kupci :set
>                      ,@(list 'ime (parameter "ime"))
>                      :where (:= 'id (parameter "id")))))
>
> I get from hunchentoot log:
>
> Database error 42883: function parameter(unknown) does not exist
> No function matches the given name and argument types. You might need to add 
> explicit type casts.
> Query: UPDATE kupci SET ime = E'a' WHERE (id = parameter(E'id'))
Try
(query (sql-compile `(:update 'kupci :set
                      ,@(list 'ime (parameter "ime"))
                      :where (:= 'id ,(parameter "id")))))
-- 
With Best Regards, Stas.