grouping cfoutputs

[ibearian]

In the below query is the number of time the group loops limited ?????

for some reason mine stops at 40 !

<cfoutput query="modsfaqs" group="modID">
#modName#<br>
<cfoutput>
#faqquestion#<br>
#faqaskedby#<br><br>
</cfoutput>
</cfoutput>


ibearian.

PROJECT H
mailto:ibearian@projecth.co.uk

 

[ecobb]

In the below query is the number of time the group loops limited?

What query? We need to see it to know what it's doing. Also, have you checked to verify that the query is pulling more than 40 results?



Hope This Helps!

Ecobb

&quot;My work is a game, a very serious game.&quot; - M.C. Escher

 

[ibearian]

sorry, the query is a simple

select *
from table a

kind of affair and should not be effected

the list is the full 49 lines when you don't use the group attribute and the additional cfoutput tags. But with it back in it seems to only loop 40 times and dump the other data

i just wasn't sure if it was limited and if it is do you know a work around or a coded solution ?

ibearian.

PROJECT H
mailto:ibearian@projecth.co.uk

 

[webmigit]

You need to add

order by modName, FAQQuestion, FAQAskedBy

to your sql statement..

That should fix it..

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.