chapter31

I just noticed this in the Adobe docs for cfqueryparam in ColdFusion 8:
Revised 8/21/2007: Removed limitation on using the cfquery cachedAfter or cachedWithin attributes with cfqueryparam.This limit no longer applies.
This is great news because before (MX7 and below):
You cannot use the cfquery cachedAfter or cachedWithin attributes with cfqueryparam.
I know many people didn’t like this limitation […]

Read the rest of this entry »

A few notes to self on generating .xls files from HTML tables, particularly with CSS.
It appears that excel only has a particular ‘range’ of hex numbers you can use (at least for background colours). I was trying to use #eeeeee; for a while (which is obviously fine for HTML and for creating a PDF), but […]

Read the rest of this entry »

Today I needed a function which would return me a whole number, rounding either up or down depending on whether the value passed to the function was less than or greater than .5
Looking at round() ColdFusion 8 docs they say:
Rounds a number to the closest integer that is larger than the input parameter.
Hmm, that doesn’t […]

Read the rest of this entry »

I’ve just created some functionality which will be executed by a ColdFusion (8 standard on Win 2003) scheduled task daily, but only for 1 month.
When I add my new task in ColdFusion administrator I can set the ‘Start Date’ ok, but not the ‘End Date’. The reason? Well I’m not sure, but it looks like […]

Read the rest of this entry »

Recently I was just comparing 2 dates (one from a query and the other was now()) using the createODBCDate() and dateCompare() functions.
I was using the createODBCDate() function because I only wanted the ‘date’ part of a date object, not the ‘time’. More than likely I should have been using dateFormat(), but that’s another story […]

Read the rest of this entry »