Re: re[2]: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Ajas Mohammed
Hello everyone, It was great learning stuff today. Let me recap 1) Thanks Dean for pointing out not to store dbname in client var and instead store in appl var 2) Mischa, your input really got it all started. As per your last email, I have made some changes and I think t

Re: [ACFUG Discuss] dynamic structs/variable

2007-03-05 Thread Jeremy Allen
You can also use the SetVariable function if you wanted to avoid the syntax magic of . Jeremy On 3/5/07, Steven Ross <[EMAIL PROTECTED]> wrote: Ok I'll let you in on it... heh. Ok so I have a configuration xml file and I want to be able to dynamically create structs and stick them in the applic

Re: [ACFUG Discuss] dynamic structs/variable

2007-03-05 Thread Steven Ross
Ok I'll let you in on it... heh. Ok so I have a configuration xml file and I want to be able to dynamically create structs and stick them in the applications configuration variable by just editing the xml file. I can't go into it in detail at the moment but, I'll follow up with a blog post about w

re[2]: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Mischa Uppelschoten ext 10
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 ContentsOfCusto

Re: [ACFUG Discuss] dynamic structs/variable

2007-03-05 Thread Steven Ross
thanks! this worked: On 3/5/07, Gurevich, Gerry (NIH/NIEHS) [C] <[EMAIL PROTECTED]> wrote: Well I would want to ask and argue not to do this...but I'll bite my tongue. Why not create a superstructure to hold this. Then you could do something like: I have not tested this,

RE: [ACFUG Discuss] dynamic structs/variable

2007-03-05 Thread Gurevich, Gerry \(NIH/NIEHS\) [C]
Well I would want to ask and argue not to do this...but I'll bite my tongue. Why not create a superstructure to hold this. Then you could do something like: I have not tested this, but it should be close to right. Come to think of it, you might even see if you could use "variables" ins

[ACFUG Discuss] dynamic structs/variable

2007-03-05 Thread Steven Ross
ok so for whatever reason (I'd rather not hear arguments why not to do this) I want to try to do this: the last part is the part I can't get to work... tired all sorts of flavors of evaluate, and I would have included a few examples of what I have tried but, figured that would confuse th

RE: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Charlie Arehart
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 us

Re: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Ajas Mohammed
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 co

re: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Mischa Uppelschoten ext 10
Yes, what you're 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 Verit

Re: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Dean H. Saxe
Well, the data for the DB is something that is specific to the app, not the client. Store it in the APPLICATION scope, not in the CLIENT scope. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] "Dissent is the purest form of patriotism." --Thomas Jefferson On Mar 5, 2007, at 10:45 AM,

Re: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Ajas Mohammed
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 g

Re: [ACFUG Discuss] CF application using verity

2007-03-05 Thread Dean H. Saxe
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" -

[ACFUG Discuss] CF application using verity

2007-03-05 Thread Ajas Mohammed
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