Query in ColdFusion
Posted on 2004-11-19
I'm fairly new to Dreamweaver/Coldfusion and was wondering how to do the following:
I have a database that I want to pull almost all the data from. For example, I have TableA with 26 fields, named A-Z in order respectively. I want to place this data into a HTML table (2x13), in a specific order that is not the order of the columns in my table. (e.g. C, Z, Y, Q…). How do I do that in one query (select * from TableA), but select the actual values from the specific fields to enter into my HTML table? That way, for each of the cells within the HTML table, I can insert the proper value from the query. Thanks.