|
| |
|
|
GPITLP
Posts: 33
Joined: 9/2/2004
Status: offline
 |
Variable Name based on DRW Field - 8/18/2006 12:33:20
I am attempting to load variables from a parameters database to be used later in the form.
Example: My table looks like this:
Field Active FieldValue Title
A 1 100 Response for Value A
S1_Q1 1 93 Product Knowledge
S2_Q3 0 90 Quality of Service
What I am attempting to do is something like this:
Param_FP_FieldVal("Field")_Active = FP_FieldVal("Active")
Param_FP_FieldVal("Field")_Value = FP_FieldVal("FieldValue")
Param_FP_FieldVal("Field")_Title = FP_FieldVal("Title")
Therefore I would have a result set of:
Param_A_Active = 1
Param_A_Value = 100
Param_A_Title = Response for Value A
Param_S1_Q1_Active = 1
Param_S1_Q1_Value = 93
Param_S1_Q1_Title = Product Knowledge
Param_S2_Q3_Active = 0
Param_S2_Q3_Value = 90
Param_S2_Q3_Title = Quality of Service
Can someone steer me in the right direction on how the syntax would look like?
THANKS
Terry
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Variable Name based on DRW Field - 8/18/2006 13:23:34
I think I see what you're trying to do and I personally would not attempt it with the DRW. Also, I don't believe you can 'rename' VBScript variables on-the-fly which is what you're trying to do.
However, I think you could do what you want quite readily by using an array. Then you'd be accessing values by using coordinates like a spreadsheet:
myArray(myColumnValue,myRowValue)
The items 'myColumnValue' and 'myRowValue" are simple integers and can be determined many, many ways programatically.
That help any? That make any sense?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
GPITLP
Posts: 33
Joined: 9/2/2004
Status: offline
|
RE: Variable Name based on DRW Field - 8/18/2006 16:15:22
Thanks for the info. I guess that's why I couldn't figure out how to do it. What I'm attempting to do is create a survey system that is flexible from survey to survey based on the parameter database.
I can use an array and make it work. They only issue is that the parameter database must remain in the same consistently or it will change the order of the array.
Is that correct or is there a smarter way?
THANKS
Terry
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
