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
[url]www.dotnetbooks.com[/url]


"my" <mypeng4@yahoo.com> wrote in message
news:03ed01c34fd0$60fc1170$a401280a@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" <mypeng4@yahoo.com> wrote in message
news:03ed01c34fd0$60fc1170$a401280a@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