September 07, 2008
For ColdFusion hosting try HostMySite.com. |
Home /
Groups /
ColdFusion Talk (CF-Talk)
ListGetAt problem distinct
http://63.144.103.199/products/index.cfm?n1ID=5&n2ID=43&n3ID=133Paul Ihrig 05/21/08 12:01 P 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>
|
Mailing Lists
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||