Hi Bill, looks like you just need to reference your getlistings query:
<!--- Loop through all listings --->
<cfloop query="getlistings">
<!--- Display listing details here --->
<!--- Display feature codes --->
<cfloop index="code" list="#getlistings.FEATURE_CODES#"
delimiters="#chr(44)#">
<cfif structKeyExists(featureCodes,code)>
#featureCodes[code]#
<cfelse>
#code#
</cfif>
</cfloop>
</cfloop>
On 1 June 2010 14:17, Bill Hartley <b...@whdservices.com> wrote:
>
> 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>
>
> -----------------------------------------------------------------------------------------------------------------------------
>
> On Mon, May 31, 2010 at 8:12 PM, Kevan Stannard <ke...@stannard.net.au
> >wrote:
>
> >
> > Hi Bill, this is the idea I was getting at:
> >
> > <!--- 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>
> >
> >
> > On 1 June 2010 09:43, Bill Hartley <b...@whdservices.com> wrote:
> >
> > >
> > > Is there a way I can do it with in the CF code on the page itself and
> not
> > > in
> > > the select statement in the query?
> > >
> > > Something like
> > > <cfset fullname="#MLS_AGENT_NAME#">
> > > #gettoken(fullname,2,",")# #gettoken(fullname,1,",")#
> > > <HR><BR></CFOUTPUT>
> > > <cfset codelist="#FEATURE_CODES#">
> > > <cfloop index="code" list="#codelist#" delimiters="#chr(44)#">
> > > <CFIF code EQ "#featurecodes.feature_codes#">
> > > #featurecodes.description#
> > > <CFELSE>
> > > #code#
> > > </CFIF>
> > > </cfloop>
> > >
> > > I know this this code is totally wrong but thats the situation that
> would
> > > help me the most....anybody know the correct way to concieve of this?
> > >
> > > On Sat, May 29, 2010 at 1:45 AM, Kevan Stannard <
> > kevan.stann...@gmail.com
> > > >wrote:
> > >
> > > >
> > > > A simple option for you is to load all of your feature codes into a
> > > > structure then loop through your feature codes list and just pull the
> > > > feature code descriptions from the struct.
> > > >
> > > > On 29/05/2010 12:37 PM, "Bill Hartley" <b...@whdservices.com> wrote:
> > > >
> > > >
> > > > I am trying to display feature codes from a comma delimited list
> inside
> > a
> > > > database. Here is my setup:
> > > >
> > > > Table: Listings has a column called FEATURE_CODES and example of the
> > data
> > > > in
> > > > this column is "B01,E09,E20,G12,J07"
> > > >
> > > > Then I have another table inside the same database called
> FeatureCodes
> > > the
> > > > data inside this table is arranged
> > > > FEATURE_CODE FEATURE_DESCRIPTION
> > > > B01 Sold As Is
> > > > E09 Frame and Stucco
> > > > and so on....
> > > > I need to display the feature description from the FeatureCodes table
> > on
> > > > the
> > > > display page by reading the feature_codes from the listing table
> > > >
> > > > Any Suggestions?? Please!!
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:334170
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
