|
Home > Archive > MySQL ODBC Connector > January 2006 > Error inserting text containing a "?" character
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error inserting text containing a "?" character
|
|
| David P. Donahue 2006-01-27, 9:23 am |
| 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
ddonahue@ccs.neu.edu
http://www.cyber0ne.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Gleb Paharenko 2006-01-27, 9:23 am |
| 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
> ddonahue@ccs.neu.edu
> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ 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/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|