I'm not really sure what you're asking. You can use the LAST_INSERT_ID() function to get the last auto-generated ID you've inserted on your current connection, if that's what you mean?
cheers, barneyb On 6/20/07, [Sunshine Tech Solutions] Ravi Gehlot <[EMAIL PROTECTED]> wrote: > I know this question is prolly out topic but he it goes. How do I sort > by the last inserted Id on a sql query? > > Ravi. > -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
