[Sqlrelay-discussion] [sqlrelay] propagating placeholders (question marks) with DBD::SQLRelay

[<b-r...@ro...>]

(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