First pass, are you asking your SQL driver to parse CF functions?
Next thought; working thru date and time comparisons between CF, native db SQL and then CF's own SQL can drive you mad. The types just don't always mesh.
What I've always done: just get dynamic MINUTES out of your database - cast as integers - as soon as you can, using the date time functions in the sql that are native to the DB you're using.
Then do all your CFML magic - query of queries, etc - by comparing those good ol fashioned numbers.
I could have missed your whole point tho. Sorry, it's late. Alan Holden -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
