Dynamic Variables

[hlukes]

I need to create a set of variables that I can reference for some formulas (var1 + var2, etc) later on in the page. The data is being pulled from a db - the variable name and the value of the variable. I am having a hard time setting the value of the variable and then being able to reference it for display or the formulas.

do until subs.eof

thisvar = thisvar & "val_" & subs("acctname")


thisvar = subs("amount")


subs.movenext
loop

subs.close
set subs=nothing

Basically "thisvar" has become the value so instead of being able to do <%=(val_ADV)%>, I just nothing because that variable has gone away. I am sure I am overlooking something simple. Help would be SO appreciated!

[jhardman]

I need to create a set of variables that I can reference for some formulas (var1 + var2, etc) later on in the page. The data is being pulled from a db - the variable name and the value of the variable. I am having a hard time setting the value of the variable and then being able to reference it for display or the formulas.

do until subs.eof

thisvar = thisvar & "val_" & subs("acctname")


thisvar = subs("amount")


subs.movenext
loop

subs.close
set subs=nothing

Basically "thisvar" has become the value so instead of being able to do <%=(val_ADV)%>, I just nothing because that variable has gone away. I am sure I am overlooking something simple. Help would be SO appreciated!

He, he, he. Silly mistake. Try:

do  until subs.eof
 
    thisvar = thisvar & "val_" & subs("acctname")
 
 
    thisvar = thisvar & subs("amount")
 
 
    subs.movenext
loop

Let me know if it helps.

Jared