Hi. The answer to this is depends on what environment (?) you are working in At least in Flowscript and xsp, you could declare a String-object and put your variable into it, then apply the Trim()-method on the new variable. Even in pure JAVA you could do this of course.
If you do your work somewhere else, this might not be the thing, I can't see from your mail if you do it in xsp. ( I don't know if esql *only* works in xsp either ) Regards /Ralph -----Ursprungligt meddelande----- Från: Fadi Qutaishat [mailto:[EMAIL PROTECTED] Skickat: den 28 juni 2005 16:23 Till: users@cocoon.apache.org Ämne: Re: SV: MySQL error on cocoon - please could some one help! Hi, An instance of the strings inside the query could be like: <query>update ms_concepts set chunk_name2_knowledge=1 where id=1</query> This works fine for the first two chunks displayed, after that I get the error, it seems that there is something added to the string each time the update is processed. How could I use the Trim() function for the above query, that might help! Regards, Fadi ____________________________________________________ Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]