How often do you index your data? If you do it daily, you could easily use a category called "Last7Days", then filter on that category.
On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215712 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