Community Member Profile

Recent Blog Comments By Paul

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Dec 15, 2009 at 3:04 PM

  I know this is an old thread, but I found something today that answers a question I put here a while back. If you ever need to clear the query cache, and don't want to (or can't) restart CF, the following works like a champ: 1. Login to your CF Admin 2. Go to the Data Source i... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Jun 5, 2009 at 10:49 AM

  I've had something like that happen when I've had code inside of <CFLOCK> statements that was bad, and caused everything to timeout (I can't remember what I had miscoded). It didn't throw a helpful error, and I only figured it out when I started commenting out portions of code.... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Feb 4, 2009 at 10:51 AM

  Ran into this again today, but not questioning the problem itself. I'm actually adding to the last post, about clearing the cache. Is there a way to clear the query cache, similar to the clear template cache button in CF admin? I'd like to be able to do this w/o a restart when the error c... read more »

• My 1,000th ColdFusion Post - What It Means To Me (And Free Prizes)

  Posted on Jan 26, 2009 at 9:06 AM

  CF is dead? That's too bad. It reminds me of the day a few years back when I heard javascript was dead, too... ;)... read more »

• The Way Of The Warrior And The Chance Not To Be Fired

  Posted on Jan 7, 2009 at 10:13 AM

  I think part of you is right, in that there is some possibility a carefully-phrased response could have deflected and maybe defused things. But, that said, this being the Internet, I'm sad to say the way of the warrior is either dead, or largely doesn't exist here. So, yes, it's *possibl... read more »

• Ask Ben: Checking Domain Name Availability Using ColdFusion

  Posted on Nov 30, 2008 at 12:12 PM

  domaintools.com has a free API access for domain searches, up to 100 queries a day. If you have more, you can get a paid subscription. http://xml-api.domaintools.com/index.php?cmd=showDescription... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Sep 19, 2008 at 9:40 AM

  I think it must be more than that, because I changed the query considerably when degugging. I took out different parts to narrow down what was the cause, and would error in different states. If it's a cache, it behaves much differently than a standard cache. If it weren't for the fact our... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Sep 17, 2008 at 12:02 PM

  1) I certainly never knew that, and wouldn't have guessed it, either, since I use it in updates, inserts, etc. I also suppose only having gotten the error in this one case, based on all of my uses of it, makes it even more suprising. I am espcially suprised because the error started hour... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Sep 17, 2008 at 11:43 AM

  It is a SELECT *, and I had added a column in the past day, but it's not a cached query. Would CF still cache anyway? I'm trying to remember the other times this has happened (it's uncommon, and my previous troubleshooting was rushed), and it's possible I had made changes around then, too.... read more »

• ColdFusion CFQueryParam Binding vs. SQL Execution

  Posted on Sep 17, 2008 at 11:14 AM

  I am finding CFQueryParam weirdness of a different sort. I have this part of a query AND lt.ltName = <CFQUERYPARAM VALUE="#REQUEST.thisProp#" CFSQLTYPE="CF_SQL_VARCHAR"> Where ltName is a varchar(50), and REQUEST.thisProp is "hartstone". The result is an "Unsupported da... read more »