Skip to main content
Ben Nadel at cf.Objective() 2012 (Minneapolis, MN) with: Mark Drew
Ben Nadel at cf.Objective() 2012 (Minneapolis, MN) with: Mark Drew ( @markdrew )

Jeff

Member since Dec 15, 2009

Recent Blog Comments By Jeff

  • Finding Template Execution Stack in ColdFusion

    Posted on May 25, 2011 at 2:53 PM

    @Ben "@Ron, From what I remember, you *might* need to have debugging turned on." I was getting the same error as Ron, on top of Enable Request Debugging Output, I had to add my IP address to the Debugging IP Addresses. Also the Post Comment button no worky in FireFox 4.... read more »

  • ColdFusion CFQueryParam Varchar-List Puts In Single Quotes For You

    Posted on Mar 28, 2011 at 11:15 AM

    @Jameson, Since you are using a list you have to use the IN operator. In your case NOT IN. Try <cfquery name="dff" datasource="#request.dsn#"> select * from courseregistration where COURSEID NOT IN (<cfqueryparam value="139,132" cfsqltype="cf_sql_... read more »

  • ColdFusion CFQueryParam Varchar-List Puts In Single Quotes For You

    Posted on Dec 30, 2009 at 3:34 PM

    @Ben, Thanks for the quick reply. Didn't get a chance to mess with this code till today. What you said works. Kind of? Maybe I can't do this with Natural joins? I now have this code... <cfquery name="GrabInfoForEmail"> Select members.firstname, members.lastname, companies.company_name FRO... read more »

  • ColdFusion CFQueryParam Varchar-List Puts In Single Quotes For You

    Posted on Dec 15, 2009 at 11:57 AM

    Ben, Thanks for this CFQueryParam List post and your previous one, it has really helped me out. But I don't know if I've found another issue that is related to this. But here's what I'm trying to do. I have two tables. Members and Companies. A Member can have multiple companies. So I have a fie... 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