Monthly Archives: October 2007
- October 31, 2007
- ColdFusion 8 can now use cacheAfter/cacheWithin when using cfqueryparam’s
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 [...]
- October 18, 2007
- Styling issues when generating an xls from HTML
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 [...]
- October 12, 2007
- ColdFusion ‘Round()’ docs inaccurate?
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 [...]
- October 8, 2007
- Can’t set a scheduled task ‘End Date’
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 [...]
- October 5, 2007
- createODBCDate() returns ‘time’ as well?
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 [...]