First thing I notice is the DB name is stored in the client scope...
I sure hope that's not stored in a client side cookie.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"[U]nconstitutional behavior by the authorities is constrained only
by the peoples' willingness to contest them"
--John Perry Barlow
On Mar 5, 2007, at 10:36 AM, Ajas Mohammed wrote:
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
