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


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 »