Re: Using sql functions

Prashant Acharekar wrote:
> (with-database (*default-database* *db* :database-type :mysql)
>       (insert-records :into "DATA"
>                       :attributes '(user_name email created_on modified_on)
>                       :values `(,user-name ,email "now()" "now()")))
> 
> The above does not work.

Dirty hack for quick fix: try |now()|.
Explanation: it will pass symbol-name into SQL (thinking it is a
reference to a column), which yields "now()".

For a real fix you may need to extend function list (which contains at
least count)