Renaming columns

[SomeJoe]

Say i'm pulling * from some table. a few of these columns are named:

First_Name
Last_Name
Date_of_Order

How can I rename these fields so it's using a different name than the one from the table in the database?

rename them to:

First Name
Last Name
Date of Order

(main point being there are spaces instead of underscores)

Thanks!

[Brent]

If you're using ASPdb, you can use the dbNameMap property. The syntax is:
x.dbNameMap="First_Name,First Name,;" You could also use the last argument in the string to change properties of the column label, for example aligning the name left.

HTH


------------
SomeJoe at 2/13/01 3:32:34 PM

Say i'm pulling * from some table. a few of these columns are named:

First_Name
Last_Name
Date_of_Order

How can I rename these fields so it's using a different name than the one from the table in the database?

rename them to:

First Name
Last Name
Date of Order

(main point being there are spaces instead of underscores)

Thanks!

[Nico]

Hey thanks that works great!

But as you stated, i can use the last argument in the string to change the properties of the column label, such as aligning it left if i wanted.

I tried that but it only aligns the actual header text and not the respective column. (i know thats what it's supposed to do im just asking another question, hehe.) Know how i would go about aligning column data to the right in just ONE column?

Thanks!


------------
Brent at 2/13/01 4:01:35 PM

If you're using ASPdb, you can use the dbNameMap property. The syntax is:
x.dbNameMap="First_Name,First Name,;" You could also use the last argument in the string to change properties of the column label, for example aligning the name left.

HTH


------------
SomeJoe at 2/13/01 3:32:34 PM

Say i'm pulling * from some table. a few of these columns are named:

First_Name
Last_Name
Date_of_Order

How can I rename these fields so it's using a different name than the one from the table in the database?

rename them to:

First Name
Last Name
Date of Order

(main point being there are spaces instead of underscores)

Thanks!

[Mark]

Use dbMagicCell. See Example 2 at:
http://www.aspdb.com/apps.
Mark.


------------
Nico at 2/13/01 4:52:48 PM

Hey thanks that works great!

But as you stated, i can use the last argument in the string to change the properties of the column label, such as aligning it left if i wanted.

I tried that but it only aligns the actual header text and not the respective column. (i know thats what it's supposed to do im just asking another question, hehe.) Know how i would go about aligning column data to the right in just ONE column?

Thanks!


------------
Brent at 2/13/01 4:01:35 PM

If you're using ASPdb, you can use the dbNameMap property. The syntax is:
x.dbNameMap="First_Name,First Name,;" You could also use the last argument in the string to change properties of the column label, for example aligning the name left.

HTH


------------
SomeJoe at 2/13/01 3:32:34 PM

Say i'm pulling * from some table. a few of these columns are named:

First_Name
Last_Name
Date_of_Order

How can I rename these fields so it's using a different name than the one from the table in the database?

rename them to:

First Name
Last Name
Date of Order

(main point being there are spaces instead of underscores)

Thanks!