CFQUERYPARAM is definitely one not to miss. Saves lots of headaches. Also, I noticed that you have your dates "backwards" in the example (i.e. you compare against the later date first). I went and looked at your first post a little closer, and they're backwards there too. It doesn't matter with the <= operators, but the BETWEEN operator has a strict order. The "lesser" one MUST be first, or you'll never get any matches.
Totally missed that the first time I looked. cheers, barneyb On Mon, 13 Dec 2004 21:06:31 -0600, Nick Baker <[EMAIL PROTECTED]> wrote: > Barney, > > Thanks for the help. Very interest. CFQUERYPARAM is one of those tags I > never bothered to look at. Now can see a lot of bennies for using. > > I also found that the searching for <= and => seems to do work, i.e., > > TransactionDateTime <= #EndDate# AND TransactionDateTime >=#StartDate# > > Nick > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54