Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Matthew Reinbold
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Matthew Reinbold@libel_vox )

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