http://63.144.103.199/products/partNumsTab3.cfm?n1ID=5&n2ID=43&n3ID=133
ok i am not getting the results i am expecting.
i took the spaces out of the db..
but Cable Management still shows multiples.
tried adding a ',' to the cfset so when the list loops it makes it one list.
bbut its not removing duplicates..
any other ideas?
Thanks!
-m
<cfquery name="getAce" datasource="xxx">
SELECT DISTINCT TOP 100 PERCENT title, specs_partnum, aId
FROM dbo.VIEWtempAsc
WHERE (aId IN (#aList#))
ORDER BY title
</cfquery>
<cfoutput query="getAce" group="title">
#title# - aId <cfoutput>#aId# </cfoutput><br />
<cfoutput><cfset theList = "#getAce.specs_partnum#," /></cfoutput>
<cfset uniqueListItems = structNew() />
<cfloop list="#theList#" delimiters="," index="i">
<cfset uniqueListItems[i] = i />
</cfloop>
<cfset cleanedList = structKeyList(uniqueListItems) />
<strong>theList</strong>: <cfoutput><strong>aId: #aId#</strong>
#theList#</cfoutput><br />
<strong>cleanedList</strong>: <cfoutput>#cleanedList#</cfoutput><br />
<br />
<br />
</cfoutput><br /><br />
db looks like
28 Cable Management _ 600 Suited 7035 700/800 Alone
9969593,9969594,9969599,9969600,9969601,9969928,9969927,9969597,9969736,9970253,9970263,9970271
175 Cable Management _ 600 Suited 9005 700/800 Alone
9969593,9969594,9969599,9969600,9969601,9969928,9969927,9969597,9969736,9970254,9970264,9970271
176 Cable Management _ 700 Suited 7035
9969599,9969600,9969601,9969928,9969927,9969597,9969736,9969595,9969598,9970255,9970265,9970271
177 Cable Management _ 700 Suited 9005
9969599,9969600,9969601,9969928,9969927,9969597,9969736,9969595,9969598,9970256,9970266,9970271
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305877
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
