Return-Path: <balld@webslingerZ.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 83946 invoked from network); 16 Jun 2000 20:40:03 -0000
Received: from benjamin.webslingerz.com (HELO localhost.localdomain)
 (206.66.49.217)
  by locus.apache.org with SMTP; 16 Jun 2000 20:40:03 -0000
Received: from localhost (balld@localhost)
	by localhost.localdomain (8.9.3/8.9.3) with ESMTP id PAA25300
	for <cocoon-users@xml.apache.org>; Fri, 16 Jun 2000 15:30:43 -0400
X-Authentication-Warning: localhost.localdomain: balld owned process doing -bs
Date: Fri, 16 Jun 2000 15:30:43 -0400 (EDT)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: balld@localhost.localdomain
To: cocoon-users@xml.apache.org
Subject: Re: sql question
In-Reply-To: <Pine.LNX.4.05.10006161500340.4880-100000@pandora.binc.net>
Message-ID: <Pine.LNX.4.10.10006161529430.25108-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

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