Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at the New York ColdFusion User Group (Apr. 2008) with:

Rich

Member since Jul 29, 2013

Recent Blog Comments By Rich

  • Cannot Use ColdFusion CFQueryParam With SQL TOP Directive

    Posted on Jul 29, 2013 at 6:01 AM

    Hi Ben, came across this when I ran into the issue in CF9, you can also fix it by multiplying by 1. SELECT TOP (1*<cfqueryparam value="#arguments.pagesize#" cfsqltype="cf_sql_integer">) Works just fine where this fails SELECT TOP <cfqueryparam value="#arguments.p... read more »