On Thursday, March 13, 2003, at 12:24 PM, Jeremy Quinn wrote:
Hi All
I have SQL Queries that worked with a (month old) CVS, but are failing with the latest CVS (and a move from JVM 1.3.1 to 1.4.1).
I am getting the following error from the SQL Transformer:
it is worse than my original post made out:
<rowset
xmlns="http://apache.org/cocoon/SQL/2.0";
xmlns:sql="http://apache.org/cocoon/SQL/2.0";
xmlns="http://apache.org/cocoon/SQL/2.0";
xmlns:sql="http://apache.org/cocoon/SQL/2.0";
xmlns="http://apache.org/cocoon/SQL/2.0";
xmlns:sql="http://apache.org/cocoon/SQL/2.0";
xmlns="http://apache.org/cocoon/SQL/2.0";>
<error>
Syntax error or access violation, message from server:
"You have an error in your SQL syntax near 'SELECTr.nameAS'resource',r.date,r.idAS'resourceid',r.title,'Image'AS'ty pe',r.des' at line 1"
</error>
</rowset>
TRIPLE namespace declarations (????)
I have updated my driver to the latest stable 'MySQL-Connector-Java', modified the driver class to be 'com.mysql.jdbc.Driver'.
The problem of munging my query continues.
Help!!!
regards Jeremy
