cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kari M. Scott" <>
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}

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


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

Berbee...putting the E in business

View raw message