Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
ListGetAt problem distinct
Author: Paul Ihrig
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56481#305827
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>
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
