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. -- Casey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:302536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4