Friday, May 18, 2001 5:14 PM
I have a table that is dynamically populated from a db to show the item
number, description, price and image of products.
Although there are several hundred items there are only about 6 prices.
Rather than inputting the price of each item into the database, I would
prefer to put a letter designation then set the letter to equal a price. so
that when prices change I only have to reset the price once per price versus
changing all the prices in my database.
I am pulling out #price# from a query.
if I use prices as a , b, c, d, ...
can I use some sort of set function to establish prices to be displayed
so if an item has a price code of "a" in the database it will display $22.00
if it is "b" then it will display $26.00
etc...
Or does this need to be done via a cfif statement and if so how would I do
it
Thank you for any help you can provide
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
