http://63.144.103.199/products/index.cfm?n1ID=5&n2ID=43&n3ID=133
if you click the accessories tab
you can see i have repeating accesories in the Fans
works fine if i pull out numbers that are repeated and add them to a new
category..
which i am probably going to make the data entry guys do...
sure this isnt making any sense..
-paul
93 9969938, 9969639, 9969936 "Fans _ Split Rear Door 7035 24"" cab
220V 9969938"
95 9969942, 9969639, 9969940 "Fans _ Split Rear Door 7035 28"" cab
220V 9969942"
27 9969937, 9969639, 9969939 "Fans _ Split Rear Door 9005 24"" cab
110V 9969937"
<cfoutput query="getAscList2" group="title">
<cfloop From = "1" To = "#ListLen(getAscList2.specs_partnum)#" index =
"Counter">
<cfoutput group="specs_partnum">
<tr align="left" valign="top">
<td>
#ListGetAt(getAscList2.specs_partnum,Counter)#
</td>
<cfquery name="prodDesc" datasource="XX">
SELECT DISTINCT specs_partnum, prod_description
FROM riprod_specs
WHERE specs_partnum = #ListGetAt(getAscList2.specs_partnum,Counter)#
</cfquery>
<td>#prodDesc.prod_description#</td>
</tr>
</cfoutput>
</cfloop>
<tr align="left" valign="top">
<td colspan="2"></td>
</tr>
</tbody>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305827
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
