Complicated variable

[xSeanx]

I have a database query, which i output and also use 2 loops in.
optionx and qtyx are loop index's.

i want to use those loop index's to output a value that is in the db query.

eg: in the database there is a table column called Product13
the value of optionx has looped to 1 and qtyx looped to 3.
how can i display the value of this column through something like
Product#optionx##qtyx#

[BSterner]

You can use the "Evaluate" function for variable variable names.

#Evaluate("Product" & optionx & qtyx)#

Can you provide a bit more information on what exactly is going on. Seems
like there should be a better way to accomplish what you're trying to do.

[Adam Cameron]

> Product#optionx##qtyx#

queryName["Product#optionx##qtyx#"][row]

Don't use evaluate() if you can possibly avoid it (generally you CAN avoid
it): it adds a lot of processing overhead.
--

Adam