MySQL error on cocoon - please could some one help!

[Fadi Qutaishat <fa...@yahoo.com>]

Hi all,

I am using the MySQL version 4.0.3 and Cocoon 2.1.6. 

In my application when it comes to update the database
after accessing a link I got the following error:

Syntax error or access violation message from server:
you have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the
right syntax to user near '= '1' where id ='2" at line
1"

The sql syntax that I am using is like:

<execute-query
xmlns="http://apache.org/cocoon/SQL/2.0">

<query>update ms_concepts set <xsl:value-of
select="$reqsymbolizedknowledge1"/>='1' where
id='<xsl:value-of select="$id"/>'</query>

</execute-query>


The updates works fine for one or two times then it
starts generating this error.

I have searched for this error and it was said this
might be a bug in this version! but I am not sure.

Any idea?

Many thanks,

Fadi   



		
____________________________________________________ 
Yahoo! Sports 
Rekindle the Rivalries. Sign up for Fantasy Football 
http://football.fantasysports.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org