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 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 »

Black Lives Matter
Ad for InVision App, Inc prototying platform.
Ad for Epicenter Consulting.