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]
