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

Reply via email to