There have been issues with certain prepared statements and older versions of MM.MySQL. I suggest you upgrade to the latest (2.0.7) available from http://mmmysql.sourceforge.net/.
You should not surround your ?'s with single quotes (leave them bare), and contrary to the previous messages, you do not need to format them in any way, the driver does this. As a notice to all who post JDBC questions to this list, here's a few suggestions: 1. Don't post them on this list, signup for the [EMAIL PROTECTED] mailing list, it's more appropriate, and the signal/noise ratio is better for JDBC issues 2. When you post, please include the driver version you are using, the mysql version you are using, the JDK version you are using, and any other specifics (such as application server version, etc). 3. Make sure that if you aren't using the latest version of the driver (you can always check at http://mmmysql.sourceforge.net), and at least check the CHANGELOG for the latest driver to make sure that your problem hasn't already been fixed. 4. Search for the answer to your question on groups.google.com before posting. There are very few new questions posted to this list that aren't answered in comp.lang.java.databases or in the archives of [EMAIL PROTECTED] and [EMAIL PROTECTED], both of which groups.google.com picks up and archives. 5. Consider reading "How to Ask Smart Questions" from Eric S. Raymond, which will improve the odds of getting your questions answered. See: http://tuxedo.org/~esr/faqs/smart-questions.html You also might want to check the mozilla bug reporting guidelines at http://www.mozilla.org/quality/bug-writing-guidelines.html Thanks, -Mark (author of MM.MySQL) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php