Hello all,
I have searched the archives and don't seem to find any reference to
metadata that is data about data.
I have a database named say kkk.
kkk has a number of tables. Using an SQL statement I have constituted
a suitable SQL Select statement for one of the tables. (There is no
error with this SQL Select statement.)
Now I am trying to make this statement generic for more than one table
(about 12 tables in all).
Again the SQL statement is not an issue. But my field names are in
metadata form. In the sense that the field names are values in
variables which are named as "field_1_name", "field_2_name".
So text variable field_1_name contains the value "APT_Application_Code"
which is the name of a field in the table tblApplication_Team.
Similarly text variable field_2_name contains the value "APT_User_ID"
which is the name of another field in the table tblApplication_Team.
Using these values in the field_1_name, field_2_name etc.. I would like
to retrieve the values in the tblApplication_Team table into other text
variables like field_1_value and field_2_value.
my problem is:
field_1_value = kkk.field_1_name.value
does not give the value as the name of the field in the table is
not "field_1_name" but the value contained in the field field_1_name
that is APT_Application_Code.
Can anyone help me with the syntax for specifying that I do not
want "field_1_name" to be considered as the field name in the table but
that it is the value contained in field_1_name which should be
considered as the field name in the table?
Thanks in advance.
Cheers!
Uttam
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
