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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
