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"

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,

Todd S. Canaday
Instructor - Adjunct Faculty
Herff College of Engineering
The University of Memphis
Memphis, TN  38152-3210
Office 218A

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to