cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: sql question
Date Fri, 16 Jun 2000 19:30:43 GMT
On Fri, 16 Jun 2000, Kari M. Scott wrote:

> 
> 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. 

try DATE_FORMAT(return,"%a, %l%p") AS formatted_date. cocoon has no idea
how to name a column something absurd like 'DATE_FORMAT(return,"%A,
%l%p")'.

- donald


Mime
View raw message