Rich
Member since Jul 29, 2013
- Profile: /members/11093-rich.htm
- Comments: 1
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 »