Can you give us an excerpt from your configuration files? It is hard to answer without it.
From: Carlos Peix [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2008 12:43 PM To: [email protected] Subject: MySql provider Hi all, We are using DataMapper version 1.6.1.0 on Net 1.1 with the MySql.Data driver, version 1.0.10.x and MySql 5.x We are surprised because seems like IBatis, with that provider at least, is building the query concatenating strings. The error arose with a Incorrect syntax exception from MySql due to a single quote ( ' ) in the comment issued to the DB. We verified that the data had that character inside but it's supposed not to affect if the query is sent with parameters. Are we missing something? Why is IBatis not sending a command with parameters? it depends on provider configuration? The problem doesn't appear with the old ByteFX provider but it doesn't work with the new authentication in MySql 5.0 Thanks and have a nice week Carlos Peix
