Billy Jamme said: > > The problem occurs when I attempt to use cfqueryparam to fetch a > 2100+ item list of records. > > <cfquery name="selectList" datasource="database"> > SELECT id > FROM tempTable > WHERE id IN (<cfqueryparam value="#list#" list="true" > cfsqltype="cf_sql_integer">) > </cfquery>
> To further troubleshoot I installed the jTBS 1.2 drivers and I ran > all 3 queries again. The result this time around was: > > Query 1: "Prepared or callable statement has more than 2000 > parameter markers." > Now the question. Is there a way to get around this limit? The limit it probably somewhere in a .properties file where you can up it and recompile the driver. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241194 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
