> THIS IS REALLY CLOSE - THANK YOU SO FAR :-)
>
> The actual list inf feature codes come from a different query and for that
> matter a different table...here is the code for the first query....I almost
> had this working and then went through a block
> So it needs to read the list of feature_codes from the first query then
> display the matching feature_description in the second query....still with
> me? :-/ is this really easier than I'm making it out to be?
>
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> <CFQUERY name="getlistings" datasource="flidx_data" MAXROWS="10">
> SELECT * FROM listings WHERE listings.TLN_FIRM_ID = '2014415' OR
> listings.TLN_FIRM_ID = '242913' OR listings.TLN_FIRM_ID = '2010937'
> ORDER BY sale_price DESC
> </CFQUERY>
>
> <!--- Get the feature codes --->
> <cfquery name="featureCodesQuery" ...>
> select feature_code, feature_description
> from featureCodes
> </cfquery>
> <!--- Put the feature codes into a struct --->
> <cfset featureCodes = {}>
> <cfloop query="featureCodes">
> <cfset featureCodes[feature_code] = feature_description>
> </cfloop>
> <!--- Display the feature codes --->
> <cfloop index="code" list="#FEATURE_CODES#" delimiters="#chr(44)#">
> <cfif structKeyExists(featureCodes,code)>
> #featureCodes[code]#
> <cfelse>
> #code#
> </cfif>
> </cfloop>
>
> -----------------------------------------------------------------------------------------------------------------------------
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334168
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
