Re: cfsearch help
Thank you so much all. jl On 7/6/06, Rob Wilkerson [EMAIL PROTECTED] wrote: John - open a word doc that isn't indexing with the title you'd like. Once it's open, click File Properties and you should be able to access the metadata. I told you that from memory, but if it's not correct let me know and I'll run it down further. On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: I don't use Word myself, just Writer, but there are Document Properties for each Word doc. Reindexing: Verity creates an index, much like what you would see in a book. Now imagine you add a new chapter to the book. Obviously the index has to be updated. Ditto for removing a chapter. The CFINDEX tag lets you perform operations to an existing index that will update the content. So basically the idea is this: When your app is being created, you typically do an index creation that gets ALL the data. Then in your Add/Edit/Delete operations, you update the index. If you download my Verity preso from last week, you will see I have an example CFC in there that shows this in action. On 7/6/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, How do you check the meta data? Can you tell me the steps for re-indexing? Thanks much. jl On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: Open the word documents and check the meta data. Ensure it is set to what you think it is. Also, do not forget that if you change the information, you then need to update the index. Verity won't know the file has changed unless you ask it to reindex the file. On 7/5/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, Did you check the documents with bad titles to make sure that they are set up right? I have tried many different ways, but no luck so far. How do you check bad titles? jl On 7/3/06, Raymond Camden [EMAIL PROTECTED] wrote: So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245805 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfsearch help
Open the word documents and check the meta data. Ensure it is set to what you think it is. Also, do not forget that if you change the information, you then need to update the index. Verity won't know the file has changed unless you ask it to reindex the file. On 7/5/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, Did you check the documents with bad titles to make sure that they are set up right? I have tried many different ways, but no luck so far. How do you check bad titles? jl On 7/3/06, Raymond Camden [EMAIL PROTECTED] wrote: So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245487 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: cfsearch help
Raymond, How do you check the meta data? Can you tell me the steps for re-indexing? Thanks much. jl On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: Open the word documents and check the meta data. Ensure it is set to what you think it is. Also, do not forget that if you change the information, you then need to update the index. Verity won't know the file has changed unless you ask it to reindex the file. On 7/5/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, Did you check the documents with bad titles to make sure that they are set up right? I have tried many different ways, but no luck so far. How do you check bad titles? jl On 7/3/06, Raymond Camden [EMAIL PROTECTED] wrote: So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245515 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: cfsearch help
I don't use Word myself, just Writer, but there are Document Properties for each Word doc. Reindexing: Verity creates an index, much like what you would see in a book. Now imagine you add a new chapter to the book. Obviously the index has to be updated. Ditto for removing a chapter. The CFINDEX tag lets you perform operations to an existing index that will update the content. So basically the idea is this: When your app is being created, you typically do an index creation that gets ALL the data. Then in your Add/Edit/Delete operations, you update the index. If you download my Verity preso from last week, you will see I have an example CFC in there that shows this in action. On 7/6/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, How do you check the meta data? Can you tell me the steps for re-indexing? Thanks much. jl On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: Open the word documents and check the meta data. Ensure it is set to what you think it is. Also, do not forget that if you change the information, you then need to update the index. Verity won't know the file has changed unless you ask it to reindex the file. On 7/5/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, Did you check the documents with bad titles to make sure that they are set up right? I have tried many different ways, but no luck so far. How do you check bad titles? jl On 7/3/06, Raymond Camden [EMAIL PROTECTED] wrote: So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245519 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: cfsearch help
John - open a word doc that isn't indexing with the title you'd like. Once it's open, click File Properties and you should be able to access the metadata. I told you that from memory, but if it's not correct let me know and I'll run it down further. On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: I don't use Word myself, just Writer, but there are Document Properties for each Word doc. Reindexing: Verity creates an index, much like what you would see in a book. Now imagine you add a new chapter to the book. Obviously the index has to be updated. Ditto for removing a chapter. The CFINDEX tag lets you perform operations to an existing index that will update the content. So basically the idea is this: When your app is being created, you typically do an index creation that gets ALL the data. Then in your Add/Edit/Delete operations, you update the index. If you download my Verity preso from last week, you will see I have an example CFC in there that shows this in action. On 7/6/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, How do you check the meta data? Can you tell me the steps for re-indexing? Thanks much. jl On 7/6/06, Raymond Camden [EMAIL PROTECTED] wrote: Open the word documents and check the meta data. Ensure it is set to what you think it is. Also, do not forget that if you change the information, you then need to update the index. Verity won't know the file has changed unless you ask it to reindex the file. On 7/5/06, John Lucania [EMAIL PROTECTED] wrote: Raymond, Did you check the documents with bad titles to make sure that they are set up right? I have tried many different ways, but no luck so far. How do you check bad titles? jl On 7/3/06, Raymond Camden [EMAIL PROTECTED] wrote: So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245524 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: cfsearch help
So you are saying sometimes the title is right, and sometimes not? Verity tries to find the title from the metadata of the document when indexing. Did you check the documents with bad titles to make sure that they are set up right? As for your second question, yes, using CF7. Simply add the contextPassages attribute to your cfsearch tag and check the contest column of the result. Oh - and get rid of that evalute. You can change it to maxRows = #Form.MaxRows + 1# On 7/1/06, John Lucania [EMAIL PROTECTED] wrote: I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245284 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
cfsearch help
I have cfsearch for Word documents in a directory, but it is not returning the results as I expect. cfsearch name = GetResults collection = MyFormSearch criteria = #LCase(Form.Criteria)# StartRow = #Form.StartRow# maxRows = #Evaluate(Form.MaxRows + 1)# title=Title The document titles are at the top (usually with one row, or with two rows if the title is long) of the document (all Word documents), but cfsearch doesn't pull out some of document titles. If possible with cfsearch, I want to show a few lines of the Word contents like Google search. Are there cfsearch examples I can use out there? TIA, JL ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245210 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
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
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
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
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
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
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 contains 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
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 CFSEARCH tag ended up looking like this: cfsearch collection=#TheCollection# name=getSearchResults type=explicit criteria='(MANYSTEM#UCase(url.criteria)#) AND ((cf_custom1 SUBSTRING #day0#) OR (cf_custom1 SUBSTRING #day1#) OR (cf_custom1 SUBSTRING #day2#) OR (cf_custom1 SUBSTRING #day3#) OR (cf_custom1 SUBSTRING #day4#) OR (cf_custom1 SUBSTRING #day5#) OR (cf_custom1 SUBSTRING #day6#) OR (cf_custom1 SUBSTRING #day7#) )' 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
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
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? cfindex query=query 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: cfindex query=query 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. ~| 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
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? cfindex query=query 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: cfindex query=query 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
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? cfindex query=query 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: cfindex query=query 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 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
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
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
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
