Error inserting text containing a ? character

2006-01-27 Thread David P. Donahue
This morning I began noticing some errors coming from my MySQL database 
that appear to be the result of a user inserting text which contains a 
question mark anywhere in it.  The error is:


Parameter '?' must be defined ...

Is there a way to tell MySQL to just treat the ? as another character 
in the string, rather than as a parameter?  Maybe have my application 
replace all occurrances of ? with something else that will represent a 
? to the database before issuing the query?


For reference, I'm using the MySQLConnector .NET for connecting my 
application to a MySQL 4.x database.



Regards,
David P. Donahue
[EMAIL PROTECTED]
http://www.cyber0ne.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Error inserting text containing a ? character

2006-01-27 Thread Gleb Paharenko
Hello.

Check that you're using the fresh enough versions of Connector/NET and
MySQL. See:
  http://bugs.mysql.com/bug.php?id=5392



David P. Donahue wrote:
 This morning I began noticing some errors coming from my MySQL database
 that appear to be the result of a user inserting text which contains a
 question mark anywhere in it.  The error is:
 
 Parameter '?' must be defined ...
 
 Is there a way to tell MySQL to just treat the ? as another character
 in the string, rather than as a parameter?  Maybe have my application
 replace all occurrances of ? with something else that will represent a
 ? to the database before issuing the query?
 
 For reference, I'm using the MySQLConnector .NET for connecting my
 application to a MySQL 4.x database.
 
 
 Regards,
 David P. Donahue
 [EMAIL PROTECTED]
 http://www.cyber0ne.com


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]