Where is the cut-off - if there is one - for what the version of Verity that comes with CF 5
will index (and allow for a successful search) as it relates to newer versions of MS Word files? It seems as if some MS Word 2003 files will not index successfully, while other more "plain vanilla" MS Word 2003 files will??? Any thoughts? Gordon Cantor [EMAIL PROTECTED] _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: Monday, March 05, 2007 12:45 PM To: [email protected] Subject: RE: [ACFUG Discuss] CF application using verity Ajas, I've seen the other replies so far, and while I'm not sure I fully understand what you're doing and asking, I'll throw out an idea you may not have considered which may be the solution for you. Did you know that since the result of the CFSEARCH is a query resultset, you can then query that using CF's "query of queries" feature? That could be a way to subset a verity search result, when for some reason you can't get Verity to do the desired subsetting for you. If you're not familiar with "query of query", see the CFMX Developer's Guide: http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/w whelp.htm?context=ColdFusion_Documentation <http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/ wwhelp.htm?context=ColdFusion_Documentation&file=00001266.htm> &file=00001266.htm Be sure to use the forward button to walk through all the pages in that section. While that link is for the CF7 docs, the feature is pretty much the same since CF5. /Charlie http://www.carehart.org/blog/ _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajas Mohammed Sent: Monday, March 05, 2007 10:37 AM To: [email protected] Subject: [ACFUG Discuss] CF application using verity Hi, I have CF application which I have designed using verity search feature. Overview : The search application lets user search data in tables based of keywords and the user could also filter by state or just say ALL ie. all states. I can get results when search is based of ALL STATES since I dont have to do anything apart from displaying results from the collection. The issue is when user searches by a particular state(only one state at a time is allowed at this time in appl). I need to somehow filter the results in the collection based of the state selected by the user. Any suggestions would be great. I need some ideas. Look at code below and code marked with my comment in red. Is it a good idea ? Here is the code just in case : Code for Collection <!--- Retrieve all StateRegs to be searched ---> <cfquery name="GetStateRegs" datasource="#client.dbname#"> SELECT reg.Reg_ID, elig.Eligibility_No, note.Note_No, reas.Reason_No, reg.Reg_Name , reg.State,reg.MaxDuration, reg.Concurrent_Policies, reg.Link, elig.Eligibility_Text, reas.Reason_Text, note.Note_Text FROM (( (Regulations reg left outer join Reason reas ON reg.Reg_ID = reas.Reason_Reg_ID ) left outer join Eligibility elig on reg.Reg_ID = elig.Elig_Reg_ID ) left outer JOIN Notes note on reg.Reg_ID = note.Note_Reg_ID ) WHERE reg.Country = 'US' ORDER BY 1,4,2,3 </cfquery> <!--- Build 'custom' index on query result above ---> <cfindex action="refresh" collection="StateRegs" key= "Reg_ID" type="custom" title="Reg_Name" query="GetStateRegs" body="Reg_Name,MaxDuration,Eligibility_Text,Reason_Text,Note_Text" custom1="Reason_Text" <<<< -- Shall I use State over here custom2="Eligibility_Text" custom3="Reason_No" custom4="Eligibility_No"> Let me know if you need any more input from my side. Thanks, -- <Ajas Mohammed /> http://ajashadi.blogspot.com ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
<<attachment: image001.jpg>>
