Hello, good people
I have a problem with placeholders and inserting a string with (a) question
mark(s) character by way of the placeholders.
I get errors from DBI saying that there is something wrong with my
SQL-string, and it shows me the error in the string, displaying an *extra*
question mark at the end of the string displaying the inserted data in
place of the placeholders...
It seems to me that the literal question mark inside a string is
interpreted as a placeholder itself, and this of course produces an error....
I have been searcing for two days now on the net, without finding the
solution to this problem. I have tried doubling the question mark ('??'
instead of '?'), I have tried quoting them using the built-in
$dbh->quote("?"), nothing works...
I am using DBI version 1.38 with DBD::mysqlPP 0.0.4...
I have been experimenting a bit, and it seems like question marks are
accepted in strings used in placeholders, *if* and only if it is in the
LAST argument in the execute() list. Now, this sounds to me like a bug...
So, any takers?
---Asgeir---
