Re: ESQL XSP problems

[Alex Greg]

Matt,


Many thanks for your help. Your suggestion resolved that particular problem:
however I now have a new error in the logs (and I'm still getting 500
Internal Server error in my browser):

[Mon Mar 10 16:16:47 2003] [warn] [client 10.10.50.11] [AxKit] fast handler
called for /axkit/xsp/dbi.xsp
[Mon Mar 10 16:16:47 2003] [warn] [client 10.10.50.11] [AxKit] some
condition failed. recreating output
[Mon Mar 10 16:16:47 2003] [error] [client 10.10.50.11] [AxKit] [Error]
Empty String at /usr/lib/perl5/site_perl/5.6.1/AxKit/XSP/Util.pm line 67

[Mon Mar 10 16:16:47 2003] [error] [client 10.10.50.11] [AxKit] From:
/usr/lib/perl5/site_perl/5.6.1/i386-linux/Apache/AxKit/Exception.pm : 9

The XSP has now changed to:

<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>username</esql:username>
        <esql:password>password</esql:password>

        <esql:execute-query>
                <esql:query>select * from topics</esql:query>
                <esql:results>
                        <topics>
                                <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>
                        </topics>
                </esql:results>
        </esql:execute-query>
</esql:connection>
</xsp:page>

Any ideas?


Regards,


Alex Greg

----- Original Message -----
From: "Matt Sergeant" <[EMAIL PROTECTED]>
To: "Alex Greg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 10, 2003 3:16 PM
Subject: Re: ESQL XSP problems


> 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]
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]