SELECT MAX(Row) AS MaxRecord WHERE MaxRecord = @@IDENTITY i believe that is the correct syntax.... beat me over the head if i'm wrong :P kev ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
- Last row inserted Joshua Tipton
- Re: Last row inserted Howie Hamlin
- Re: Last row inserted Gene Kraybill
- Re: Last row inserted Kevin Mansel
- Re: Last row inserted Michael Lugassy