Dynamic Variables (again)

[FateFirst]

Apologies for reposting this, but many people just see a post with lots of replies as being solved so I have re-posted it.

Anyways, apologies once again, but here it is with more of an explanation.

------------------------------------------------
Lets say 1 table contains 5 fields:

table_id
table_main_1
table_main_2
table_main_3
table_main_4

Do the usual methods to get the data then assign the data to the variables. As you can see the names of the variables take their name from the field name:

table_id = objRecordSet("table_id&quot
table_main_1 = objRecordSet("table_main_1&quot
table_main_2 = objRecordSet("table_main_2&quot
table_main_3 = objRecordSet("table_main_3&quot
table_main_4 = objRecordSet("table_main_4&quot

Now instead of having to do the above assigning bit manually, I just want to be able to just change the SQL statement and it will dynamically build the above using the field names as the names of the variables and the field content as the data assigned to each variable. Is this possible, and if so which is the best way around this.

Just as a note I dont really want to use sessions though, as it is quite resource intensive.
------------------------------------------------ - FateFirst

 

[RushiShroff]

Try this..

for i=0 to 4
 if i=0 then
   table_id = objRecordSet(i)
 else
   table_id_& i = objRecordSet(i)
end if
next

but you have to be careful at Dtabase field names.

Right !!
Rushi Shroff Rushi@emqube.com
"Life is beautiful."

 

[FateFirst]

Ok.

But what I really want is it to pull the field names out and dynamically create the variable then use the field content to fill the variable. Then move onto the next field and so on.

So if I was to edit the SQL statement and add another field to pull into it, it would automatically create the *new* variable and put the information in it without me having to hard code the new field in.

Am i confusing everyone else as well as myself

Sorry, but its quite complex! - FateFirst