Hello experts.
I have a working code:
<cfloop query="artikel" startRow="#StartRow_artike
l#">
<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>
<cfoutput>#artikel.Herstel
ler_DE# </cfoutput>\<cfoutput> #arraytolist(listtoarray(v
aluelist(g
etextras.E
xtra_DE,',
')),', ')#
</cfoutput>
</cfloop>
How can i have so many rows for each page like the maxrows value i have?
The way it is now working is like that:
I have all the results on one page and because the maxrows is working too i have the other pages too.
Start Free Trial