<html><body><div style="color:#000; background-color:#fff; font-family:lucida console, sans-serif;font-size:10pt"><div><div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">hello all,</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">i'm not sure what to make of this...</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;"><br></font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">"SELECT * FROM t WHERE t.AgencyID in (996,998,1195)"</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">returns all records where AgencyID one of 996, 998, or 1195...no problem here.</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;"><br></font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">now, let's say i have an array-> SqlBind(1) =
"996,998,1195"</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">and i use this format -> <span class="Apple-tab-span" style="white-space:pre"> </span> "SELECT * FROM t WHERE t.agencyid IN (:1)"</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;"><br></font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">when i run:</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">db.SqlSelect(SQLQuery, kClientSide, kNoLocks, kForwardOnly, SQLBind)</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">only records where t.AgencyID = 996 are returned.</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;"><br></font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">is this normal?</font></div><div><font size="2" style="font-family:
arial, helvetica, sans-serif;">can't binding be used with "IN"?</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;"><br></font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">thanks,</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;">george</font></div><div><font size="2" style="font-family: arial, helvetica, sans-serif;"><br></font></div><div><br></div></div></div></div></body></html>