On Mon, 10 Mar 2003, Alex Greg wrote:
> <xsp:page language="Perl" xmlns:xsp="http://apache.org/xsp/core/v1";
> xmlns:esql="http://apache.org/xsp/SQL/v2";>
> <esql:connection>
> <esql:driver transactions="no">mysql</esql:driver>
> <esql:dburl>dbname=axkit;host=localhost;port=3306</esql:dburl>
> <esql:username>root</esql:username>
> <esql:password>S1leX99</esql:password>
>
> <esql:execute-query>
> <esql:query>select * from topics</esql:query>
> <esql:row-results>
> <topic>
> <id><esql:get-int column="id" /></id>
> <title><esql:get-xml column="title" /></title>
> <description><esql:get-xml column="description"
> /></description>
> </topic>
> </esql:row-results>
> <esql:results>
> <topics>
> </topics>
> </esql:results>
Looks like you got some tags inside-out. Should be:
<esql:results>
<topics>
<esql:row-results>
...
</esql:row-results>
</topics>
</esql:results>
--
<!-- Matt -->
<:->get a SMart net</:->
Spam trap - do not mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
