Hi all - I've got a problem using Cocoon 2.0.3 in that I can't seem to delete a record from the database I'm using. Didn't see anything on the archive list related to this. I can add records just fine, but when I execute the code to delete a record, I get the following:
"org.apache.cocoon.ProcessingException: Could not delete record :position = 0: java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near '' at line 1..." When I change the <map:act type="delete"> in the sitemap to <map:act type="add">, I get the confirmation page and the display of the values within the database that I should get if this were an actual delete. Any other way will throw the error above. I'm using the following within my sitemap: <map:action name="delete" logger="sitemap.action.delete" src="org.apache.cocoon.acting.DatabaseDeleteAction"/> I'm using MySql version 3.23.56 with the appropriate driver. I also have delete access granted to the user on MySql - so it's not an access problem. Actually, I'm re-writing an example out of the book "Cocoon Developers Handbook" in Ch. 12 - and have this working like it should (there is no example of deleting a record from the database, though). What confuses me is that I get a SQL syntax error. I have written a page to delete a record using ESQL - and that works fine - but it doesn't fit into the overall site plan. My development setup is described below: Windows XP Tomcat 4.0.5 Cocoon 2.0.3 MySql 3.23.56 Any thoughts? Thanks in advance, tsc Todd S. Canaday Instructor - Adjunct Faculty Herff College of Engineering The University of Memphis Memphis, TN 38152-3210 Office 218A http://www.people.memphis.edu/~tcanaday/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
