[Sqlrelay-discussion] [sqlrelay] propagating placeholders (question marks) with DBD::SQLRelay
Brought to you by:
mused
|
From: <b-r...@ro...> - 2009-07-06 17:06:33
|
(Hmm. It's been three weeks since my last posts and there have been
absolutely no responses. I'll try one more time with something new...)
I'm using DBD::SQLRelay as it purports to be directly compatible with Perl
DBI. This means doing my database accesses the same way as always,
supposedly.
I attempted to enter (insert or update) column values that include
question marks ('?'). This fails, with each question mark being translated
to :1 :2 :3 (etc). I tried every method of escaping and quoting I could
think of, to no avail. I was using $dbh->do() directly, with and without
placeholders.
I next went back to basics: Create a simple table and a short script to
use placeholders and insert a column that contained a '?'.
If I used 'DBI' for a direct connection to the MySQL database, it worked.
If I used DBD::SQLRelay (to take advantage of connection pooling), MySQL
rejected the SQL statement due to the '?' being translated to ':1' - bad
syntax.
What gives? How can I properly use placeholders with the DBD::SQLRelay?
Thanks.
--
Roger
|