That's what switch/case statements are for... Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _____________________________ http://blog.cutterscrossing.com
Casey Dougall wrote: > Hi > > I have a query that spits back things like Types of floor coverings: > "Hardwood, Linoleum, Vinyl" > > The third party service states that for each listing, they only take > particular values for Floor Covering. > > "Hardwood, LinoleumVinyl" > > So I loop through and set the XML nodes according to how they need them > worded. > > <cfloop query="FloorCoverings"> > > <CFIF FloorCovering EQ "Hardwood"> > > <Flooring>Hardwood</Flooring> > > <CFELSEIF FloorCovering CONTAINS "Linoleum" OR FloorCovering CONTAINS > "Vinyl" > > > <Flooring>LinoleumVinyl</Flooring> > > </CFIF> > > </cfloop> > > Considering I need to do this 15 or 20 times including things like roof > types, appliances etc, seems like I'm going about this all wrong. > Seems like I should almost create a table in the database and store > associations there but I would still need to do a lookup x amount of times > per listing. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302537 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
