Are u ordering your query by the ordernumber as well so that all the items are in the correct order for the cfoutpur.
-----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]
