<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><FONT face="Courier New, Courier, Monospace">Hey SPUG Team,</FONT><BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace">How does one turn off the annoying and sometimes unneeded auto-quoting that occurs during <FONT face="">DBI</FONT> Bindings? I have searched the net for a while now and have found little on the subject.</FONT><BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace">example:</FONT><BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace">$<FONT face="">sql</FONT> = <FONT face="">q</FONT>(<FONT face="">thrrr_id</FONT> in (?));</FONT><BR>
<FONT face="Courier New">$sth = $<FONT face="">dbh</FONT>->prepare($<FONT face="">sql</FONT>);</FONT><BR>
<FONT face="Courier New">$sth->execute( q(1,2,3,4,5) );</FONT><BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace"><FONT face="">DBI</FONT> executes this: <FONT face="">thrrr_id</FONT> in ('1,2,3,4,5') </FONT><BR>
<FONT face="Courier New, Courier, Monospace">But I want to execute this: <FONT face="">thrrr_id</FONT> in (1,2,3,4,5) </FONT><BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace"><FONT face="">DBI</FONT> adds quotes and I don't want them. If there is no way around this I can forgo the performance/convenience of bindings.</FONT><BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace">Thank you SPUG Team!</FONT><BR>
<FONT face="Courier New, Courier, Monospace"></FONT> <BR>
<FONT face="Courier New, Courier, Monospace">Stephen<BR></FONT><BR></body>
</html>