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