Re: [postmodern-devel] Calling a SQL func as a DAO field value

25 Dec 2012

      On Tue, Dec 25 2012, Marijn Haverbeke wrote:
...
If I do
cl-user> (s-sql:sql (:now))
It produces "now()" for me.
Sure, for me too. So let me give you a bit more context.

If you've a class like:

(defclass user ()
 ((mytimestamp :col-type timestamp :accessor mytimestamp))
 (:metaclass dao-class))

And try to do:
(setf (mytimestamp user) '(:now))
(update-dao user)

This raises things like:
      Value (:NOW) can not be converted to an SQL literal.

at run-time.

Maybe `setf' is not the right way to modify this field here?

-- 
Julien Danjou
# Free Software hacker & freelance
# http://julien.danjou.info