Re: [castor-dev] enclosing quotes in SQL statement not being added

2002-07-16 Thread Patrick van Kann
Hi Marc, I executed the following code in a test case using the mm MySQL drivers and it worked, single quotes/funny characters and all. Can I recommend you try the mm drivers and see if the problem goes away? I could not get Resin's drivers to work. My configs are below. Cheers, Patrick pub

Re: [castor-dev] enclosing quotes in SQL statement not being added

2002-07-15 Thread Marc Dugger
I'm using MySQL-Max-3.23.51 with Resin's JDBC driver. My mapping.xml is attached. Thanks! -Original Message- From: Patrick van Kann [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 9:51 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] enclosing quotes in SQL sta

Re: [castor-dev] enclosing quotes in SQL statement not being added

2002-07-15 Thread Patrick van Kann
What database are you using? I have seen similar behaviour before in either DB2 or MS SQL Server, but I resolved it. If you could post the full mapping and your database vendor I will see if I can find what caused it (and what the resolution was) Patrick Marc Dugger wrote: >The mapping I'm h

[castor-dev] enclosing quotes in SQL statement not being added

2002-07-15 Thread Marc Dugger
The mapping I'm having problems with is below: When attempting to insert a database record, the single quotes that delimit a string in a SQL statement are not being added by Castor. As a result, I get a SQL exception. As a test, I hand-coded the quotes around the strings and the st