This forum doesn't allow attachments, you'll have to put code into email.
----- Original Message -----
From: "Ken Ketsdever" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 10:28 PM
Subject: RE: setting values Close but no Cigar
> Thank you for your help!
>
> I like your idea it sounds simpe enough yet....
>
> I have probably made some simpe error that prevents this from working, but
I
> am new to CF and don't know all the ins and outs.
>
> I am attaching the file with my code. Any ideas on where I've gone wrong?
>
> Thanks again for all your help
>
> Ken
>
> -----Original Message-----
> From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 18, 2001 7:01 PM
> To: CF-Talk
> Subject: RE: setting values
>
>
> You could do this with two tables in your database and do a join. This is
> probably best as the data will be consistant no matter how you access it.
>
> A good way to do this with CF is to create a structure like this:
>
> <cfscript>
> Prices=StructNew();
> Prices.A=19.95;
> Prices.B=21.95;
> Prices.C=22.95;
> ...
> ...
> ...
>
> </cfscript>
>
>
> You could then reference the actual prices by #Prices.A#
>
> Again, a database join might be a better solution but the above will be
> functional.
>
> Matt
>
>
>
> -----Original Message-----
> From: Ken Ketsdever [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 18, 2001 9:32 PM
> To: CF-Talk
> Subject: setting values
>
>
> 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
