SPUG: Turning off auto-quoting during DBI Binding.

Stephen Blum zstephenblum at hotmail.com
Mon Apr 7 20:30:35 PDT 2008

Hey SPUG Team,
How does one turn off the annoying and sometimes unneeded auto-quoting that occurs during DBI Bindings?  I have searched the net for a while now and have found little on the subject.
$sql = q(thrrr_id in (?));
$sth = $dbh->prepare($sql);
$sth->execute( q(1,2,3,4,5) );
DBI executes this:           thrrr_id in ('1,2,3,4,5') 
But I want to execute this:  thrrr_id in (1,2,3,4,5) 
DBI adds quotes and I don't want them.  If there is no way around this I can forgo the performance/convenience of bindings.
Thank you SPUG Team!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/pipermail/spug-list/attachments/20080407/7481690e/attachment.html 

More information about the spug-list mailing list