Community Member Profile
Adam Dray
Member since Dec 11, 2008
- Profile: /members/1428-Adam-Dray.htm
- Comments: 1
- Points: 1
Recent Blog Comments By Adam Dray
-
Ask Ben: Pulling SQL Records Based On A List Of IDs
Posted on Sep 26, 2007 at 11:10 AM
When I could trust my input data, I have used dynamic SQL queries with an IN statement: WHERE b.id IN (<cfoutput>#lstID#</cfoutput>) The IN statement essentially just becomes a series of OR statements in the query. Most RDBMSes enforce a maximum list size (probably a... read more »
