Skip to main content
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Brian Rinaldi
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Brian Rinaldi ( @remotesynth )

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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel