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 [...]
- 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), [...]
- 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. [...]
- 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 [...]
- 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 [...]