Its stored in the client variable so I dont think its a client side cookie.
We use client variables that are stored in db for most of our applications.
If its a bad practice then we will create new thread as it might help me and
others. But at this moment my need is based on verity and how can i get it
to work by filtering results by state.
Thanks,
On 3/5/07, Dean H. Saxe <[EMAIL PROTECTED]> wrote:
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
-------------------------------------------------------------
--
<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 http://www.fusionlink.com
-------------------------------------------------------------
