The MAXROWS attribute restricts the output to only 1 record, and that's what it is doing. Using maxrows in conjunction with GROUP can be painful and probably best avoided. If however you want to output all the items for a given order then why don't you just conditionally constrain the orderId field with a where clause in the query and do without the maxrows?
> -----Original Message----- > From: Giles Roadnight [mailto:giles.roadnight@;goldcockerelbooks.co.uk] > Sent: 04 November 2002 16:17 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Maxrows and grouping > > > The first example is outputting both orders (numbers 5182 and > 5183) The > second example is only outputting the first order but only one of the > items associated with that order (1) > > I want to be able to output all the items associated with the first > order only so I want: > > 5182 > 1 2 3 4 5 17 18 6 7 8 9 10 11 12 > > > Giles Roadnight > http://giles.roadnight.name > > > -----Original Message----- > From: Snake [mailto:snake@;snakepit.net] > Sent: 04 November 2002 16:14 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Maxrows and grouping > > The example u have given is only outputting the first order, so what's > the problem exactly ? > > > > -----Original Message----- > From: Giles Roadnight > [mailto:giles.roadnight@;goldcockerelbooks.co.uk] > Sent: 04 November 2002 16:10 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Maxrows and grouping > > > Hi guys. > > I have this code: > > <cfoutput query="getInvoicesReturn" group="ordernumber"> > <h2>#ordernumber#</h2> <cfoutput> #booknumber# </cfoutput> </cfoutput> > > That gives me this output: > > 5182 > 1 2 3 4 5 17 18 6 7 8 9 10 11 12 > 5183 > 1 2 3 4 5 17 18 6 7 8 9 10 11 12 > > This is all well and good but I want to output only the first order so > this code: > > <cfoutput query="getInvoicesReturn" group="ordernumber" maxrows="1"> > <h2>#ordernumber#</h2> <cfoutput> #booknumber# </cfoutput> </cfoutput> > > gives me this output: > > 5182 > 1 > > How can I get it to only give me the first order? I am sure I have got > this to work before but I can't remember how. I could do it > with IF's of > course - only outputting the line if the order number is the > same as the > last one but I would rather do it another way if possible. > > > Giles Roadnight > http://giles.roadnight.name > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] For > human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
