I'm trying to do a simple XSP to access a database and generate some XML using the ESQL taglib. After solving a few initial problems with not having closed a tag (duh!) I now get a meaty Perl error in my error log:
[Mon Mar 10 13:09:48 2003] [warn] [client 127.0.0.1] [AxKit] fast handler called for /axkit/xsp/dbi.xsp [Mon Mar 10 13:09:48 2003] [warn] [client 127.0.0.1] [AxKit] some condition failed. recreating output [ the perl script follows in here ] [Mon Mar 10 15:26:20 2003] [error] [client 10.10.50.11] [AxKit] [Error] Compilation failed: Global symbol "$col" requires explicit package name at (eval 13) line 31. Global symbol "$ancestor" requires explicit package name at (eval 13) line 31. Global symbol "$format" requires explicit package name at (eval 13) line 31. Global symbol "$col" requires explicit package name at (eval 13) line 31. Global symbol "$ancestor" requires explicit package name at (eval 13) line 31. Global symbol "$col" requires explicit package name at (eval 13) line 31. Global symbol "$ancestor" requires explicit package name at (eval 13) line 31. Global symbol "$col" requires explicit package name at (eval 13) line 36. Global symbol "$ancestor" requires explicit package name at (eval 13) line 36. Global symbol "$format" requires explicit package name at (eval 13) line 36. Global symbol "$col" requires explicit package name at (eval 13) line 36. Global symbol "$ancestor" requires explicit package name at (eval 13) line 36. Global symbol "$col" requires explicit package name at (eval 13) line 36. Global symbol "$ancestor" requires explicit package name at (eval 13) line 36. Global symbol "$col" requires explicit package name at (eval 13) line 41. Global symbol "$ancestor" requires explicit package name at (eval 13) line 41. Global symbol "$format" requires explicit package name at (eval 13) line 41. Global symbol "$col" requires explicit package name at (eval 13) line 41. Global symbol "$ancestor" requires explicit package name at (eval 13) line 41. Global symbol "$col" requires explicit package name at (eval 13) line 41. Global symbol "$ancestor" requires explicit package name at (eval 13) line 41. syntax error at (eval 13) line 49, at EOF (eval 13) has too many errors. [Mon Mar 10 15:26:20 2003] [error] [client 10.10.50.11] [AxKit] From: /usr/lib/perl5/site_perl/5.6.1/Error.pm : 148 Any ideas how to resolve this? It looks like it's being run with strict pragmas and various variables haven't been pre-defined, but I can't believe that I'm the only person using ESQL to be experiencing this. My XSP page is as follows: <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> </esql:execute-query> </esql:connection> </xsp:page> Thanks in advance, Alex Greg
