Tweaking til I got it fully functional required <CFIF
#Listfind(fullList,"#i#")#>
Not being a high end coder, I have no idea why that finally worked. But it
did.
At 04:36 PM 5/6/04, you wrote:
>I'd remove the .jpgs so your list is just "1,130,130A,130E,2,23,3,30".
>Then loop over that and do
><cfif listFind(fullList,i)>
>#i#.jpg
></cfif>
>
>That should do it. My code may not be perfect, you may need to tweak it
>some but it should get you started. Look at the docs to see how to use
>listFind()
>
>John Burns
>
>-----Original Message-----
>From: Alan Bleiweiss [mailto:[EMAIL PROTECTED]
>Sent: Thursday, May 06, 2004 5:45 PM
>To: CF-Talk
>Subject: RE: Problem only showing swatches if list contains a swatch
>name
>
>When I use this code, I get no match results, and doing a dump shows me
>that the only list-item in "fullList" is the last item in the original
>list
>
>At 02:25 PM 5/6/04, you wrote:
> ><cfset
> >fullList="1.jpg,130.jpg,130A.jpg,130E.jpg,2.jpg,23.jpg,3.jpg,30.jpg">
> ><cfset thisList="2,23,23E,30,130,130A,130E">
> >
> ><cfloop list="#thislist#" index="I">
> ><cfif listFind(fullList,i & ".jpg")>
> >#i#
> ></cfif>
> ></cfloop>
> >
> >Or to make it easier, strip the jpg off the end of the file names in
>the
> >full list (if you know they are always jpgs and append that where
>you're
> >outputting #i#.
> >
> >John Burns
> >
> >-----Original Message-----
> >From: Alan Bleiweiss [mailto:[EMAIL PROTECTED]
> >Sent: Thursday, May 06, 2004 4:16 PM
> >To: CF-Talk
> >Subject: Problem only showing swatches if list contains a swatch name
> >
> >In a product display page I need to show color swatches based on only
> >those colors a particular product has available, rather than showing
>all
> >color swatches in my swatch image directory.
> >(Entire code set and table creation code at bottom of this email)
> >
> >EXPLANATION:
> >
> >I have two lists -
> >
> >One is a comma delimited list stored in one field in my database, the
> >field name is "Colors". Example content:
> >
> >2,23,23E,30,130,130A,130E
> >
> >The other is a list of files in a directory (using CFDIRECTORY to pull
> >the
> >list)
> >Example content:
> >
> >1.jpg,130.jpg,130A.jpg,130E.jpg,2.jpg,23.jpg,3.jpg,30.jpg
> >
> >I'm lost as to how to run a comparison on the two lists and bring back
> >only those JPG files that match the Colors data field.
> >
> >And here's what I've done to create a table showing the swatches
> >I know this is incorrect but don't know how to run my comparison.
> >
> ><!--------
> >SWATCH DISPLAY PAGE CODE FOLLOWS
> >----------->
> >
> ><!--------
> >QUERY TO GET COLORS for this specific product
> >----------->
> ><CFQUERY NAME="GetProduct" DATASOURCE="#EComDB#">
> >SELECT Colors
> >FROM Products
> >WHERE SiteID='#SiteID#'
> >AND ProductUnique = '#PrId#'
> ></CFQUERY>
> >
> ><!----------
> >CFDIRECTORY TAG to create list of all swatch images
> >------------>
> ><cfdirectory
> > action = ""> > > directory =
> >"c:\inetpub\wwwroot\briona\firstavenue\sites\cdusa\shop\ColorCharts\Eur
>o
> >peanNaturals"
> > name = "GetSwatches"
> > filter = "*.jpg">
> >
> ><!----------
> >SWATCH TABLE DISPLAY CODE FOLLOWS:
> >------------>
> ><TABLE BORDER="1">
> ><CFSET #count# = 1>
> ><CFLOOP QUERY="GetSwatches">
> ><CFOUTPUT>
> >
> ><CFSET ThisName=#Replace(#Name#,".jpg","","ALL")#>
> >
> ><!----------
> >COMPARE COLORS DATA FIELD TO THIS SWATCH-
> >THIS IF STATEMENT IS MY PROBLEM, I'M SURE
> >------------->
> ><CFIF #GetProduct.Colors# CONTAINS #ThisName#>
> >
> ><!---------
> >START A NEW ROW
> >----------->
> ><CFIF #COUNT# EQ 1>
> ><TR>
> ></CFIF>
> >
> ><TD ALIGN="CENTER" VALIGN="TOP"><IMG
> >SRC="" ALT="#ThisName#">
> ><BR>
> ><FONT SIZE="1" FACE="Arial,Helvetica">#ThisName#
> ><BR>
> ><INPUT TYPE="Radio" NAME="MyColorChoice"
> >VALUE="#ThisName#"></FONT></TD>
> >
> ><CFSET #COUNT# = #COUNT# +1>
> >
> ><!---------
> >END TABLE ROW AFTER 8 CELLS
> >----------->
> ><CFIF #COUNT# GT 8>
> ></TR>
> ><CFSET #COUNT# = 1>
> ></CFIF>
> >
> ></CFIF>
> >
> ></CFOUTPUT>
> ></CFLOOP>
> >
> ></TABLE>
> >
> >----------
> >[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads]
> >[<http://www.houseoffusion.com/lists.cfm/link=i:4:162466>This Message]
> >[<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
> >[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=3784.3524.
>4>Fast
> >Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
> >
> >
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads]
>[<http://www.houseoffusion.com/lists.cfm/link=i:4:162487>This Message]
>[<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
>[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=3784.3524.4>Fast
>Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
>
>----------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
