I upgraded from Debian's version of AxKit (1.5) to the latest in
CPAN (1.6), and now an XSP file utilizing ESQL that previously
worked is resulting in the following error:
Compilation failed: syntax error at (eval 13) line 65, near "q||{ "
syntax error at (eval 13) line 68, near ";
."
Apache's error log reveals the following generated code leading
up to and including the error.
---
46 { my $text = $document->createTextNode(q| AND
47 newsletter.name = |);$parent->appendChild($text); }
48 { my $elem =
$document->createElementNS(q|http://apache.org/xsp/SQL/v2|,q|esql:parameter|);$parent->appendChild($elem);
$parent = $elem; }
49 $parent->setAttribute(q|type|,q|string|);
50 {
51 my $text = $document->createTextNode("".do {
52 $cgi->param(q|newsletter|)}); # non xsp tag
53 $parent->appendChild($text);
54 }
55 $parent = $parent->getParentNode;
56 { my $text = $document->createTextNode(q| AND
57 newsletter.customer = customer.id
58 |);$parent->appendChild($text); }
59 $parent = $parent->getParentNode;
60 { my $elem =
$document->createElementNS(q|http://apache.org/xsp/SQL/v2|,q|esql:max-rows|);$parent->appendChild($elem);
$parent = $elem; }
61 { my $text = $document->createTextNode(q|1|);$parent->appendChild($text); }
62 $parent = $parent->getParentNode;
63 { my $elem =
$document->createElementNS(q|http://apache.org/xsp/SQL/v2|,q|esql:results|);$parent->appendChild($elem);
$parent = $elem; }
64 { my $elem =
$document->createElementNS(q|http://apache.org/xsp/SQL/v2|,q|esql:row-results|);$parent->appendChild($elem);
$parent = $elem; }
65 $parent->setAttribute(q|image|, "". q||{ my $elem =
$document->createElementNS(q|http://apache.org/xsp/SQL/v2|,q|esql:get-string|);$parent->appendChild($elem);
$parent = $elem; }
66 $parent->setAttribute(q|column|,q|header_image|);
---
Finally, here is the portion of the XSP code that formerly worked
that seems relevant:
---
<esql:connection>
<esql:driver>Pg</esql:driver>
<esql:dburl>dbname=kb</esql:dburl>
<esql:username>nobody</esql:username>
<esql:password></esql:password>
<esql:execute-query>
<esql:query>
select newsletter.header_image
from newsletter, customer
where customer.name = <esql:parameter
type="string"><param:customer/></esql:parameter> AND
newsletter.name = <esql:parameter
type="string"><param:newsletter/></esql:parameter> AND
newsletter.customer = customer.id
</esql:query>
<esql:max-rows>1</esql:max-rows>
<esql:results>
<esql:row-results>
<xsp:attribute name="image">
<esql:get-string column="header_image"/>
</xsp:attribute>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
---
I'm afraid that my Perl skills are insufficient to resolve this,
so any and all help would be greatly appreciated. The machine is
using Perl 5.6.1 from a Debian package; I've forced a re-install
of ESQL from CPAN to no avail.
--
John R. Daily [EMAIL PROTECTED]
Projects Manager Progeny Linux Systems
Master of the ephemeral epiphany
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
