cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: C2+ MacOS X + MySQL
Date Tue, 30 Apr 2002 22:43:04 GMT
On 30.Apr.2002 -- 05:27 PM, zack@nostromocorp.com wrote:
> i"m sorry about the HTML text, didn't even realize it was enabled.
> 
> Here's my XSP code:
> 
> <esql:connection>
>         <esql:pool>mySql</esql:pool>
>          <esql:execute-query>SELECT ID,Date,Status from 
> Messages</esql:execute-query>

This is the problem: 
esql:execute-query needs to span the entire query, i.e. after
esql:results. In addition you need a esql:query tag around the
query (like you did with the execute-query tag).

>                         <esql:results>
>                          <messages>
>                          <esql:row-results>
>                                 <message>
>                                         <id> <esql:get-long 
> column="ID"/> </id>
>                                         <datetime> <esql:get-date 
> column="Date"/> </datetime>
>                                         <status> <esql:get-string 
> column="Status"/> </status>
>                                         <fetchurl> not yet implemented 
> </fetchurl>
>                                 </message>
>                          </esql:row-results>
>                          </messages>
>                       </esql:results>
> </esql:connection>

	Chris.

-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message