cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kari M. Scott" <kmsc...@pandora.binc.net>
Subject sql question
Date Fri, 16 Jun 2000 20:08:35 GMT

Cocoon isn't happy with the sql DATE_FORMAT function. Is there a way to
make it happy?

Here is my query:
 <query connection="connection1" doc-element="HERE" row-element="HEREROW">
        select staff_id, here, DATE_FORMAT(return, "%a, %l%p")
        from attendance
        where staff_id={@staff_id}
 </query>

"return" is a DATETIME data type field. It works like a charm from the
mysql command line, but Cocoon returns no data. 

-Kari


Kari M. Scott
Berbee
5520 Research Park Drive
Madison, WI  53711-5377
kmscott@berbee.com
608.288.3000 ext. 1223
608.298.1223 direct dial
608.288.3037 fax

Berbee...putting the E in business



Mime
View raw message