Link to home
Start Free TrialLog in
Avatar of Arachn1d
Arachn1d

asked on

Getting the row I just inserted

Using CFQUERY and SQL, how do I get the row I just inserted - I have a column that is an AutoNumber, and I need to get the number of the record I just added so I can refer to it in other tables. Help!
ASKER CERTIFIED SOLUTION
Avatar of FRehman
FRehman

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Arachn1d
Arachn1d

ASKER

Not really what I was looking for, but I came up with an alternative in the mean time.