Paul

Recent Blog Comments By Paul

• CFCs Are Cached, CFIncludes Are Not

  Posted on Sep 29, 2011 at 2:43 PM

  I need to ask the same question as above, and how do you clear this caching? I have a cfc throwing an error, which I fix and repost, and still in error. I add an error to the page, and it's still only the old error. I *delete* the page, and it's still working. Before I break out the the proton... read more »

• Creating In-Memory Tables In SQL For Joining And Sumarizing

  Posted on Jul 6, 2010 at 2:54 PM

  Is there reason or argument against using QueryNew() to build a temp table of data? I was just setting up a page that will need to hold data from two databases, and wasn't sure which would work out better.... read more »

• AxisFault: ColdFusion Web Services And XML Data Types

  Posted on Apr 7, 2010 at 12:54 PM

  Never mind...I found your "Posting XML With ColdFusion..." post,and saw the use of GetHttpRequestData() to get that body info. Once I threw taht at the top of the component in an THIS scope, it worked fine. Thanks for the pre-answer.... read more »

• AxisFault: ColdFusion Web Services And XML Data Types

  Posted on Apr 7, 2010 at 10:44 AM

  I'm having difficulty similar to Charles. I am trying to pass in xml via cfhttp, but it's not being seeing by the cfc. The xmlCall is data I've created using CFXML (and passes the IsXML test). <CFHTTP RESULT="callAns" URL="APIatron.cfc?method=test_call"> <CFHTTPPARAM TYPE="header" NAME... read more »

• 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 in question. 3. Ch... 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 comes up.... 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 *possible* you c... 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 custome... 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 hours after ... 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. I supp... 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 data conversion" err... read more »