Skip to main content
Ben Nadel at InVision In Real Life (IRL) 2018 (Hollywood, CA) with: David Fraga and Clark Valberg
Ben Nadel at InVision In Real Life (IRL) 2018 (Hollywood, CA) with: David Fraga@davidfraga ) and Clark Valberg@clarkvalberg )

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 »