Fantastic. It works. Thanks for everything. -Zack
-----Original Message----- From: Christian Haul [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 5:43 PM To: [EMAIL PROTECTED] Subject: Re: C2+ MacOS X + MySQL 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]> --------------------------------------------------------------------- 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]>
