House of Fusion
Home of the ColdFusion Community
Hostmysite ColdFusion Hosting

Search cf-talk

September 07, 2008

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
   1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30         

Subscribe Now
Fusion Authority Quarterly Update - ColdFusion 8 Special Edition

For ColdFusion hosting try HostMySite.com.
Search over 2,500 ColdFusion resources here  >>>      
Home /  Groups /  ColdFusion Talk (CF-Talk)

ListGetAt problem distinct

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Paul Ihrig
05/21/2008 12:01 PM

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>


<< Previous Thread Today's Threads Next Thread >>

Mailing Lists