Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

Adam Dray

Member since Dec 11, 2008

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 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 around 256) and you... read more »