Re: cfindex/cfsearch help with dates
Here's what I do. I file this under the category "elegant hack". The content that I want to index resides in a table. To over-simplify, the table contains a numeric identifier (key), text and date fields. I create a collection that indexes just text search terms (i.e. just the text fields). I have an "advanced search" interface. If the text field is a Verity term (I created a UDF that determines if the search is Verity or not), I search against my collection and return a resultset of just keys. I then create a list of those keys. Finally, I pass that list of keys (I return a max of 1,000) in to a standard SQL query "IN" statement within the WHERE clause that filters the other defined parameters of the SQL query (including any date logic). Works great, I don't have to be limited by having only 4 CUSTOM fields, it gives me far more search flexibility, and it only adds a bit of overhead to the verity search. Pete ~| 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:215820 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
RE: cfindex/cfsearch help with dates
Ray, PROBLEM SOLVED Here's how I ended up doing it: First, I had to store my 'modifiedDate' value in custom1 with an identifier (since I was already using custom1 and custom2 for other values), so it looks like this: custom1= "identifier|mm/dd/|" Then, before my CFSEARCH, I created 7 variables with the last 7 days in them respectively formatted like this: Day0 = |08/19/2005| Day1 = |08/18/2005| Day2 = |08/17/2005| and so on... Then, my And finally...it works.. I need no Query of Queries anymore and I avoided creating two separate collections. The keys to this solution were twofold. One, you have to use 'cf_' prefixed to your cfsearch results field (i.e. cf_custom1, cf_title) to search it. I found this FINALLY in the docs, and of course the other was figuring out how to store the date in a field that was already occupied, and by using the pipes, I can properly identify the date now. Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 9:46 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Actually, you can use the CUSTOM1 field instead. The only difference is how you run your cfsearch. ** 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:215795 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
Re: cfindex/cfsearch help with dates
You can't do a comparison like that. What I meant was to use CUSTOM1 with 2 strings, New or Old. Then in your search, you would do #form.searchterms# and CUSTOM1 New This says - search on the value of form.searchterms AND restrict it to where CUSTOM1 contains New. On 8/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Is it possible to specify values for the custom1 or custom2 field in my > CFSEARCH tag? I don't find that in the docs. > > Can I add this to my criteria?: > > custom1 >= #dateadd('d',-7,now())# > > or something like that? > > I'm going to try something like this. I'll let you know how it works... > > Dave > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Friday, August 19, 2005 9:46 AM > To: CF-Talk > Subject: Re: cfindex/cfsearch help with dates > > > Actually, you can use the CUSTOM1 field instead. The only difference > is how you run your cfsearch. > > ** > 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. > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215760 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
RE: cfindex/cfsearch help with dates
Is it possible to specify values for the custom1 or custom2 field in my CFSEARCH tag? I don't find that in the docs. Can I add this to my criteria?: custom1 >= #dateadd('d',-7,now())# or something like that? I'm going to try something like this. I'll let you know how it works... Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 9:46 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates Actually, you can use the CUSTOM1 field instead. The only difference is how you run your cfsearch. ** 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:215753 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
Re: cfindex/cfsearch help with dates
Actually, you can use the CUSTOM1 field instead. The only difference is how you run your cfsearch. On 8/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Unfortunately we're on MX 6.1 here. I will let you know how the QofQ works. > But that's good to know information anyway for other projects I do (I have MX > 7 on my own servers). > > Thanks! > > Dave > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Friday, August 19, 2005 8:56 AM > To: CF-Talk > Subject: Re: cfindex/cfsearch help with dates > > > CFMX7 dramatically improved the Verity support within CFMX. One of the > new features is categories. So consider the follow example - you index > your content daily. For content where the data is older than 7 days, > you assign the category Old. For content within 7 days, you assign the > category New. > > On the CFSEARCH side, you can then filter based on category=New, or > Old, or don't worry about it. > > If you go to my blog, you can download the powerpoint and watch the > preso I did yesterday on CFMX7 and Verity. (It's a recorded Breeze > preso, so you get to hear my lovely voice and see my handsome face. ;) > > ** > 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:215752 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
RE: cfindex/cfsearch help with dates
Unfortunately we're on MX 6.1 here. I will let you know how the QofQ works. But that's good to know information anyway for other projects I do (I have MX 7 on my own servers). Thanks! Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 8:56 AM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates CFMX7 dramatically improved the Verity support within CFMX. One of the new features is categories. So consider the follow example - you index your content daily. For content where the data is older than 7 days, you assign the category Old. For content within 7 days, you assign the category New. On the CFSEARCH side, you can then filter based on category=New, or Old, or don't worry about it. If you go to my blog, you can download the powerpoint and watch the preso I did yesterday on CFMX7 and Verity. (It's a recorded Breeze preso, so you get to hear my lovely voice and see my handsome face. ;) ** 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. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215750 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
RE: cfindex/cfsearch help with dates
Bucket anyone :-) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 19 August 2005 13:56 To: CF-Talk Subject: Re: cfindex/cfsearch help with dates CFMX7 dramatically improved the Verity support within CFMX. One of the new features is categories. So consider the follow example - you index your content daily. For content where the data is older than 7 days, you assign the category Old. For content within 7 days, you assign the category New. On the CFSEARCH side, you can then filter based on category=New, or Old, or don't worry about it. If you go to my blog, you can download the powerpoint and watch the preso I did yesterday on CFMX7 and Verity. (It's a recorded Breeze preso, so you get to hear my lovely voice and see my handsome face. ;) On 8/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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:215749 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
Re: cfindex/cfsearch help with dates
CFMX7 dramatically improved the Verity support within CFMX. One of the new features is categories. So consider the follow example - you index your content daily. For content where the data is older than 7 days, you assign the category Old. For content within 7 days, you assign the category New. On the CFSEARCH side, you can then filter based on category=New, or Old, or don't worry about it. If you go to my blog, you can download the powerpoint and watch the preso I did yesterday on CFMX7 and Verity. (It's a recorded Breeze preso, so you get to hear my lovely voice and see my handsome face. ;) On 8/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > 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. > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215748 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
RE: cfindex/cfsearch help with dates
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
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. > > 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
RE: cfindex/cfsearch help with dates
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
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. On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I was wondering that. It's a bit unclear, but that sort of makes sense. > However, it's too bad it can't be done with a custom index. I know I could > put a date in the custom1 or custom2 field, but I'm trying to avoid having a > QofQ on the client side, just for performance sake. I was trying to figure > out if there is a way to do it with the criteria options in the cfsearch tag, > but so far, no luck. At this stage, I will probably build a QofQ to do it > unless someone else comes up with something. > > Thanks Ray, > > Dave > > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 18, 2005 5:14 PM > To: CF-Talk > Subject: Re: cfindex/cfsearch help with dates > > > After rereading your post, I believe the doc is referring to the > indexing of files, like Word docs, that have a date property. I don't > believe you can do this with custom indexes. > > ** > 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:215707 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
RE: cfindex/cfsearch help with dates
I was wondering that. It's a bit unclear, but that sort of makes sense. However, it's too bad it can't be done with a custom index. I know I could put a date in the custom1 or custom2 field, but I'm trying to avoid having a QofQ on the client side, just for performance sake. I was trying to figure out if there is a way to do it with the criteria options in the cfsearch tag, but so far, no luck. At this stage, I will probably build a QofQ to do it unless someone else comes up with something. Thanks Ray, Dave -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 5:14 PM To: CF-Talk Subject: Re: cfindex/cfsearch help with dates After rereading your post, I believe the doc is referring to the indexing of files, like Word docs, that have a date property. I don't believe you can do this with custom indexes. ** 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. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215702 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
Re: cfindex/cfsearch help with dates
After rereading your post, I believe the doc is referring to the indexing of files, like Word docs, that have a date property. I don't believe you can do this with custom indexes. On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I found this quote in the docs for MX 6.1 under 'composing search > expressions': > > "if a document field named DATE is defined, you can search for documents > dated prior to and including December 31, 1999 by entering DATE <= 12-31-99 > in your search." > > Now, if this is true, theoretically I could return a query with a date I want > to search by, and when I do my cfindex, I would specify it like this? > > collection="collection" > action="update" > type="custom" > key="key" > title="title" > body="body,date" > custom1="custom1" > custom2="custom2" > > > > Then, when I search on this index, i could say search for: "stuff AND DATE > >= 01-01-05" This would return only the documents which have a 'date' > greater than Jan. 1 of this year AND have the word 'stuff' in them. > > Now, here's my problem...it seems that Oracle won't allow me to alias a > column in the table I'm getting the query from as 'DATE'. So, I tried this > with the actual date field, call it 'DateField' and did my index like this: > > collection="collection" > action="update" > type="custom" > key="key" > title="title" > body="body,DateField" > custom1="custom1" > custom2="custom2" > > > > So, then I tried the query but used DateField >= instead of DATE >= and it > still doesn't work. > > So now I'm beginning to wonder if there is there a way to query a collection > by a date field. If so, what am I doing wrong? > > Thanks, > > Dave > ** > 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:215701 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
Re: cfindex/cfsearch help with dates
I'm not sure why it isn't working, but you could use QueryOfQuery to rename the column back to Date. On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I found this quote in the docs for MX 6.1 under 'composing search > expressions': > > "if a document field named DATE is defined, you can search for documents > dated prior to and including December 31, 1999 by entering DATE <= 12-31-99 > in your search." > > Now, if this is true, theoretically I could return a query with a date I want > to search by, and when I do my cfindex, I would specify it like this? > > collection="collection" > action="update" > type="custom" > key="key" > title="title" > body="body,date" > custom1="custom1" > custom2="custom2" > > > > Then, when I search on this index, i could say search for: "stuff AND DATE > >= 01-01-05" This would return only the documents which have a 'date' > greater than Jan. 1 of this year AND have the word 'stuff' in them. > > Now, here's my problem...it seems that Oracle won't allow me to alias a > column in the table I'm getting the query from as 'DATE'. So, I tried this > with the actual date field, call it 'DateField' and did my index like this: > > collection="collection" > action="update" > type="custom" > key="key" > title="title" > body="body,DateField" > custom1="custom1" > custom2="custom2" > > > > So, then I tried the query but used DateField >= instead of DATE >= and it > still doesn't work. > > So now I'm beginning to wonder if there is there a way to query a collection > by a date field. If so, what am I doing wrong? > > Thanks, > > Dave > ** > 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:215697 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
cfindex/cfsearch help with dates
Hi, I found this quote in the docs for MX 6.1 under 'composing search expressions': "if a document field named DATE is defined, you can search for documents dated prior to and including December 31, 1999 by entering DATE <= 12-31-99 in your search." Now, if this is true, theoretically I could return a query with a date I want to search by, and when I do my cfindex, I would specify it like this? Then, when I search on this index, i could say search for: "stuff AND DATE >= 01-01-05" This would return only the documents which have a 'date' greater than Jan. 1 of this year AND have the word 'stuff' in them. Now, here's my problem...it seems that Oracle won't allow me to alias a column in the table I'm getting the query from as 'DATE'. So, I tried this with the actual date field, call it 'DateField' and did my index like this: So, then I tried the query but used DateField >= instead of DATE >= and it still doesn't work. So now I'm beginning to wonder if there is there a way to query a collection by a date field. If so, what am I doing wrong? Thanks, Dave ** 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. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215672 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