Name Map from variables

[martin]

Hello,

I'd like to know if it's possible to supply variables to a name map.

For example, some of my column names are year1, year2, year3 where year 1
is always the current year, year2 is current plus 1

I would like the name map to display year1 as: cstr(Year(Now())),
year 2 as cstr(Year(Now()) + 1), etc

Can somebody please help?

Thank you,

[Frank Kwong]

just construct the property string the way you want... use a variable like

s=cstr(Year(Now())) + .....
response.write(s)
x.dbnameMap="f1,," & s


------------
martin at 2/18/2002 3:35:56 PM


Hello,

I'd like to know if it's possible to supply variables to a name map.

For example, some of my column names are year1, year2, year3 where year 1
is always the current year, year2 is current plus 1

I would like the name map to display year1 as: cstr(Year(Now())),
year 2 as cstr(Year(Now()) + 1), etc

Can somebody please help?

Thank you,

[Frank Kwong]

just construct the property string the way you want... use a variable like

s=cstr(Year(Now())) + .....
response.write(s)
x.dbnameMap="f1,," & s


------------
martin at 2/18/2002 3:35:56 PM


Hello,

I'd like to know if it's possible to supply variables to a name map.

For example, some of my column names are year1, year2, year3 where year 1
is always the current year, year2 is current plus 1

I would like the name map to display year1 as: cstr(Year(Now())),
year 2 as cstr(Year(Now()) + 1), etc

Can somebody please help?

Thank you,