
July 8th, 2004, 03:02 PM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
HELP! Display static text with query results
I am pretty new to CF and have had this question bugging me for awhile now. I really hope that I can get some answers through this forum. Here is what I am trying to do: I have a data dictionary table that has 2 columns: column_name and comments. The comments explain the fields that are listed in the column_name (i.e. First_Name (column_name), "This field holds the users first name" (comments)). What I am trying to do is create a help file for each page on my site, these help files will pull the comments info from the database and display it on the screen to explain to the user what each field is for. It would be very easy to just pull and display the column_name and cooresponding comments from the DB and then display them in a cfoutput tag. However, instead of displaying the column_name (which has underscores and abbreviations) to the user, I would like to display some static text instead of the column name. So, instead of the column_name (i.e. First_Name) I would like to display something like "User's First Name". I have gotten suggestions before to add another column to the table that can hold an alias and then pull the alias and the cooresponding comment out to display them. Although this would work perfectly, I would like to see if there are other options. Can anyone help me?
|