Ray, Can you elaborate on that idea? We do index daily. I'm unclear on how you're using the word 'category' but very interested. One thing I don't want to do is add another index based on another query (that limits records to those modified last 7 days) as this would extend the index job time which is already at almost 2 hours.
I'll be working on the QofQ today. Thanks, Dave -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 6:12 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates 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. ****************************************************************************************** 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:215744 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
