Variable in the field name.

[my]

Hi All,

I have one question. Usually, we can get data from table
by using rst("userid") because we know the column name
userid. Now, I have a variable to hold the column name. I
want to get data value like this rst(var1). However, I got
an error message.

Thanks.
my

[Manohar Kamath [MVP]]

What was the error message? Make sure that the variable does not contain any
leading/trailing spaces. A better idea is to do:

rst(Trim(var1))

Also, print out the variable and see if that field exists in the resultset.

--
Manohar Kamath
Editor, .netBooks
www.dotnetbooks.com
"my" <my*****@yahoo.com> wrote in message
news:03****************************@phx.gbl...

Hi All,

I have one question. Usually, we can get data from table
by using rst("userid") because we know the column name
userid. Now, I have a variable to hold the column name. I
want to get data value like this rst(var1). However, I got
an error message.

Thanks.
my

[Aaron Bertrand - MVP]

What is the code? What is "var1"? What does the table structure look like?
What is the error message?

In case there's any doubt, some information is better than none. :-)
"my" <my*****@yahoo.com> wrote in message
news:03****************************@phx.gbl...

Hi All,

I have one question. Usually, we can get data from table
by using rst("userid") because we know the column name
userid. Now, I have a variable to hold the column name. I
want to get data value like this rst(var1). However, I got
an error message.

Thanks.
my