October 8, 2008 03:54am pdt

1. SidFishes 199,471
2. Zvonko 133,994
3. gdemaria 104,710
4. _agx_ 75,657
5. Plucka 64,800
6. SBennett 58,100
7. dgrafx 53,464
8. erikTsomik 48,000
9. hielo 40,450
10. zadoc 39,230
11. Mr_Nil 24,500
12. srikanthm... 20,810
13. pmascari 20,750
14. meverest 20,700
15. azadisaryev 20,100
16. Jester_48 16,200
17. msfletch 15,948
18. angelIII 15,700
19. Kerrdo 15,300
20. rob_loren... 14,360
21. BSSupport 14,200
22. pigmentarts 12,000
23. js_vaughan 9,250
24. digicidal 9,150
25. HuyBD 8,800

1. mrichmon 1,346,158
2. trailblazzy... 693,166
3. pinaldave 662,896
4. anandkp 591,655
5. SidFishes 575,421
6. dgrafx 565,402
7. gdemaria 546,631
8. _agx_ 424,122
9. Plucka 406,168
10. Tacobell777 390,907
11. Jester_48 387,445
12. danrosent... 348,915
13. mkishline 295,040
14. mmc98dl1 271,238
15. entrance... 248,605
16. SBennett 243,190
17. jyokum 238,673
18. usachrisk... 237,378
19. rob_loren... 224,358
20. cheekycj 205,597
21. jimmy282 198,834
22. hart 192,788
23. substand 189,138
24. CFDevHead 178,970
25. Mause 172,288

04.07.2008 at 02:06PM PDT, ID: 23302785

	[x] Attachment Details

coldfusion cfoutput with maxrow and startrow instead of cfloop

Asked by panosms in ColdFusion Application Server, Cold Fusion Markup Language

Tags: Adobe, COLDFUSION

Hello experts.
I have two different codes for my result page.
the first code is giving for each art_Id the corresponding data from the column Besonderheiten with the function to have not more han 4 values .
the second code is doing what i want too,to replace the values from the column besonderheiten with the values from the extra_de column.
The problem i have is that i have build the page with the first code and with startrow ,maxrows and other functions for the repeat region.
how can i get the function from the second code into the first?
Any help?Start Free Trial

         
           
             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:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:

           
           
             Recordset:
<cfquery name="artikel" datasource="#dsn#">
 SELECT a.Art_ID,a.Besonderheiten,H_All.Hersteller_DE
 FROM dbo.artikel a
 LEFT JOIN H_All ON (a.Hersteller_ID = H_ALL.Herst_ID)
   #PreserveSingleQuotes(WADbSearch1.whereClause)#
 ORDER BY #PreserveSingleQuotes(sql_orderby)#
</cfquery>
Database:
table artikel:
column art_Id   besonderheiten
         1        10,20,30,40,50,60
         2        30,60,80,70
         3        50,60,90,100
table Extras_DE:
Extra_Id      Extra_DE
 10            value1
 20            value2
 30            value3..........
code one:
<cfoutput query="artikel" startRow="#StartRow_artikel#" maxRows="#MaxRows_artikel#">
#WADAdboartikel.Hersteller_DE# <cfset loopCount = 4 />
                      <cfset count_Items = ListLen(WADAdboartikel.Besonderheiten) />
                        <cfif count_items LT loopCount>
                          <cfset loopCount = count_items />
                            </cfif>
                      <cfloop from="1" to="#loopCount#" index="i">
                        <span class="textresult">#ListGetAt(WADAdboartikel.Besonderheiten,i)#</span>
                        <cfif i NEQ loopCount>,</cfif>
                        </cfloop>
                      <cfif count_items GT loopCount>
                        ...
                        </cfif> 
</cfoutput> 
 
code two:
<cfloop query="artikel">
    <cfquery name="getExtras" datasource="#dsn#">
      SELECT Extra_DE
      FROM Extras_All 
     <cfif Len(artikel.Besonderheiten)>
      WHERE extra_ID in (#artikel.Besonderheiten#)
      <cfelse>
      where 1=2
     </cfif>
    </cfquery> <table width="100" border="1">
  <tr>
    <td><cfoutput>#artikel.art_ID#</cfoutput></td>
    <td><cfoutput>#arraytolist(listtoarray(valuelist(getextras.Extra_DE,',')),', ')#               
      </cfoutput></td>
  </tr>
</table></cfloop>

           
         

Keywords: coldfusion cfoutput with maxrow and …

	Title
1	Wrong cfoutput
2	Wrong cfoutput.
3	Unexpected results when trying to incr…
4	Problem with cfoutput in resultpage
5	Displaying maxrows for update.
6	Get the maxrows value to the cfloop t…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

coldfusion cfoutput with maxrow and startrow instead of cfloop

Asked by panosms in ColdFusion Application Server, Cold Fusion Markup Language

Tags: Adobe, COLDFUSION

About this solution