Lets illustrate <cfquery name="qAFL" datasource="AussieRules" maxrows="1"> SELECT club_name FROM CLUBS ORDER BY SUCCESS DESC </cfquery>
If all is correct your database should draw out the 'Hawthorn Football Club'. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron DC Sent: Friday, 2 April 2004 3:03 PM To: CFAussie Mailing List Subject: [cfaussie] RE: how can i last result in a table (mysql) ??? Do a reverse sort and set cfquery maxrows = 1? Aaron ----- Original Message ----- From: "Kevin Faulkner" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, April 02, 2004 2:43 PM Subject: [cfaussie] RE: how can i last result in a table (mysql) ??? > unfortunately TOP's not supported in most (if not all?) mySQL, I > think the > way is to use LIMIT. > ( from mySQL.org ... SELECT a FROM tbl_name WHERE a=10 AND B=1 ORDER > BY a LIMIT 10 ) > > > ----- Original Message ----- > From: "Barry Beattie" <[EMAIL PROTECTED]> > To: "CFAussie Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, April 02, 2004 2:38 PM > Subject: [cfaussie] RE: how can i last result in a table (mysql) ??? > > > do a decending/reverse order and select top 1 > > select top 1 from tGroup DEC > > > -----Original Message----- > From: rob [mailto:[EMAIL PROTECTED] > Sent: Friday, 2 April 2004 2:35 PM > To: CFAussie Mailing List > Subject: [cfaussie] how can i last result in a table (mysql) ??? > > sorry i know a dumb question but i really need to know!! > > its friday!!! > > > Robert Shaw > Online Learning > [EMAIL PROTECTED] > MLC School > Rowley Street > Burwood 2134 > Phone: 97471266 > Mobile: 0422222515 > Fax: 97453254 > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To > unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
