Well, that sounds good on the QofQ...I know it's faster than re-querying the database, but sounds pretty quick based on what you said. I'm going to have to use it anyway, I don't have much of an option. In this case, I need to search for documents (and query results) modified within the last 7 days, so I'll just use the QofQ to make it work.
Thanks! Dave -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 5:35 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Another option you may want to consider. If your date searching can be a bit "loose", you can use categories, with names like May2005, April2005, etc. This would allow you to match eocuments wihin a month. Or even CategoryTree=2005,Category=2004. You couldn't do everything _before_ a day, but, it's an option. Also - I'd reconsider your QofQ. We use it for a large site and it works very quickly. We do an initial CFSEARCH and then 20 QofQs to filter out various parts of the results. ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215709 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54