SteveG
Posts: 56
|
| Posted: 04/29/2004, 9:28 PM |
|
Trying to spice up the look of a grid by displaying member names with a background color to match their membership level. I've got hidden UserName and ColorCode fields reading fine from the MySQL. My rows, roughly, are as follows:
Control Source Type: Code Expression
Control Source: ("<font style='BACKGROUND-COLOR: #".ColorCode."'>"UserName."</font>")
Content: HTML
Produces: UserName
Control Source Type: DataBase Expression
Control Source: CONCAT("<font style='BACKGROUND-COLOR: #",ColorCode,"'>", UserName,"</font>")
Content: Text
Produces: [Can't reproduce this in forum, but you can try it, doesn't work]
Control Source Type: Code Expression
Control Source: ("<font style='BACKGROUND-COLOR: #".ColorCode."'>"UserName."</font>")
Content: Text
Produces: <font style='BACKGROUND-COLOR: #ColorCode'>UserName</font>
Control Source Type: DataBase Expression
Control Source: CONCAT("<font style='BACKGROUND-COLOR: #",ColorCode,"'>",UserName,"</font>")
Content: HTML
Produces: <font style='BACKGROUND-COLOR: #daa520'>SteveG</font>
That last one looks interesting, but it's not rendered as html but as text defining the html. I'm trying to avoid coding as I'll be using this feature in many of my pages and it's easier to enter it as directly as possible. Any ideas?
|
 |
 |
|
