Jeff

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 »