Thank you for your reply,
I am using Microsoft Access 2002.
I actually tested something similar (and I did test your code again too) but I
came up with a different problem both times... I end up receiving all the
records, not just the ones between the correct dates. I can't figure out why.
I ran a test with cfoutput:
<cfoutput>
dateMin: #dateMin#<br />
dateMax: #dateMax#<br />
dateMinNew: #dateMinNew#<br />
dateMinNew: #dateMaxNew#<br />
<cfoutput>
and the page returned:
dateMin: 01/01/2007
dateMax: 03/31/2007
dateMinNew: {ts '2007-01-01 00:00:00'}
dateMinNew: {ts '2007-03-31 23:59:59'}
so I know my variables are being set correctly but I keep getting incorrect
results.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2744
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
