Community Member Profile

Recent Blog Comments By Ryan Guill

• Getting The Decimal Part Of A Number In ColdFusion

  Posted on May 7, 2007 at 9:18 AM

  I didn't do speed tests, but why not this? <cfset number = 3.14159 /> <cfset decimal = number - int(number) /> <cfdump var="#decimal#">... read more »

• Force ColdFusion Server To Recompile A ColdFusion Template

  Posted on May 2, 2007 at 8:22 PM

  Chances are its not coldfusion that is not recompiling, it is probably the webserver itself (apache, iis, etc). If the filesize doesn't change, sometimes it wont pull the file again. One time, I was even getting a 404 not found error on a file that I knew existed and I was beating my head... read more »

• Spacious Formatting For Inline ColdFusion Variable Evaluation

  Posted on Apr 30, 2007 at 8:07 AM

  I don't find that very readable at all. Im sure ever situation is different and you are forced to write code like that sometimes, but if it starts getting unreadable, and especially if you are having to do the same code more than once, why not pull the logic out into a udf? even if its on the s... read more »

• SQL Aggregates Support CASE Statements

  Posted on Mar 15, 2007 at 1:01 PM

  You can actually make it simpler. because you are just counting, you can use a 1 instead of the field for the value to count, and if you want a null, you can just leave out the else: # COUNT( # CASE # WHEN did_date = 0 # THEN 1 # END # )... read more »

• Could Not Unlock The Names Lock "GOOGLE.TXT" Because No Lock Is Known By That Name

  Posted on Jan 30, 2007 at 7:55 AM

  Is this code recently written? the name google.txt seems strange to me, only because it possibly may be that cf is thinking that is a variable of some sort? Does it error every time, or just once in a blue moon?... read more »