Ah, you spotted that, I'll revoke my rant about large or poorly indexed tables then.
However I do think you should use what the DB offers.... select * from myTable order by id desc limit 1 Is obviously there for a reason! ----- Original Message ----- From: "Aaron DC" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, April 02, 2004 3:40 PM Subject: [cfaussie] RE: how can i last result in a table (mysql) ??? > Ah I see... no I meant > > <CFQUERY ... MAXROWS =1> > > etc. > > Aaron > > ----- Original Message ----- > From: "Aaron DC" <[EMAIL PROTECTED]> > To: "CFAussie Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, April 02, 2004 3:38 PM > Subject: [cfaussie] RE: how can i last result in a table (mysql) ??? > > > > The question was how to grab the last result in a table. > > > > Why do you ask if it would be a waste of time ? > > > > Aaron > > > > ----- Original Message ----- > > From: "Gareth Edwards" <[EMAIL PROTECTED]> > > To: "CFAussie Mailing List" <[EMAIL PROTECTED]> > > Sent: Friday, April 02, 2004 3:05 PM > > Subject: [cfaussie] RE: how can i last result in a table (mysql) ??? > > > > > > As in <cfoutput query="query" maxrows="1"> ??? > > > > If you were to do this wouldnt you be getting all of the rows from the > > table. Wouldnt this be a waste of time? > > > > Gareth. > > > > > > > > --- > > 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
