On 30.Apr.2002 -- 05:27 PM, [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
