My whole suggestion
about combining State and Reason_Text in
one custom field, was so that you wouldn't
have to sacrifice the Reason_Text
Without trying to understand
too much of your query...
step 1: run query
SELECT field1, field2,
..., Reason_Text + "|" + State AS ContentsOfCustomField1
...
step 2: index query
<cfindex action=""
.. custom1="ContentsOfCustomField1"
... >
step 3: Fire verity
query
<cfset myCriteria
= form.UserSubmittedCriteria>
<- probably need to filter this for abuse
<cfif form.State
NEQ "All">
<cfset
myCriteria = myCriteria & "AND custom1
<CONTAINS> " & form.State>
<- not sure if you need angle brackets
around "contains"
</cfif>
<cfsearch collection="bla"
criteria = "#myCriteria#"
...>
I hope that makes
sense.
/m
: Change the search
page so that if the user chooses a state
other than all, the
: following would be added to your Verity query: custom1 CONTAINS [state] : By verity query, do you mean the query which is used for building collection? : If it is, then dont you think it will be too much to index the collection : everytime based of the state? Sorry if I am missing something obvious here... : : how do you combine 2 columns in custom field? Like this maybe : custom1="Reason_Text" contains "Eligibility_Text" custom2="state" : custom3="whatever" custom4="anythying" : Thanks : : : : On 3/5/07, Mischa Uppelschoten ext 10 <[EMAIL PROTECTED]> : wrote: : : Yes, what youre suggesting is a good idea, however, I would go a bit further : and place both Reason_Text and State in that first custom field by simply : delimiting the data. Change the search page so that if the user chooses a : state other than all, the following would be added to your Verity query: : : custom1 CONTAINS [state] : : (Depending on the value of Reason_Text, you may get too many hits and you can : resolve that by including the delimiter char in the search (you may have to : escape it) or query of query or something). : /m : : : : : 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 theuser. 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="" : : 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 : : ------------------------------------------------------------- : Mischa Uppelschoten : The Bankers Exchange, Inc. : 2020 Hills Avenue NW : Atlanta, GA 30318 : Phone: (404) 605-0100 ext. 10 : Fax: (404) 355-7930 : Web: www.BankersX.com : Follow this link for Instant Web Chat: : http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN : : ----------------------- Original Message ----------------------- : : From: "Ajas Mohammed" <[EMAIL PROTECTED]> : To: discussion@acfug.org : Date: Mon, 5 Mar 2007 10:36:34 -0500 : 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 apartfrom 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="" : 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 : ------------------------------------------------------------- : ------------------------------------------------------------- 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 : ------------------------------------------------------------- : -- : <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 : ------------------------------------------------------------- Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone: (404) 605-0100 ext. 10 Fax: (404) 355-7930 Web: www.BankersX.com Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN ----------------------- Original
Message -----------------------
From: "Ajas Mohammed" <[EMAIL PROTECTED]>
Date: Mon, 5 Mar 2007 11:29:02
-0500
Subject: Re: [ACFUG Discuss]
CF application using verity
By verity query, do you mean the query which is used for building collection? If it is, then dont you think it will be too much to index the collection everytime based of the state? Sorry if I am missing something obvious here... how do you combine 2 columns in custom field? Like this maybe custom1="Reason_Text" contains "Eligibility_Text" custom2="state" custom3="whatever" custom4="anythying" Thanks On 3/5/07, Mischa Uppelschoten
ext 10 <[EMAIL PROTECTED]>
wrote:
-- <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 ------------------------------------------------------------- ------------------------------------------------------------- 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 ------------------------------------------------------------- |
- [ACFUG Discuss] CF application using verity Ajas Mohammed
- Re: [ACFUG Discuss] CF application using v... Dean H. Saxe
- Re: [ACFUG Discuss] CF application usi... Ajas Mohammed
- Re: [ACFUG Discuss] CF application... Dean H. Saxe
- re: [ACFUG Discuss] CF application using v... Mischa Uppelschoten ext 10
- Re: [ACFUG Discuss] CF application usi... Ajas Mohammed
- re[2]: [ACFUG Discuss] CF applicat... Mischa Uppelschoten ext 10
- Re: re[2]: [ACFUG Discuss] CF ... Ajas Mohammed
- RE: [ACFUG Discuss] CF application using v... Charlie Arehart
- [ACFUG Discuss] Versions of Verity - i... Gordon Cantor
- RE: [ACFUG Discuss] Versions of Ve... Charlie Arehart