I think that if you do the query within a stored procedure, you'll be able
to get the ID back out...
> select max(id) as maxID from tablename
>
> ----- Original Message -----
> From: "Matt Eschenbaum" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 6:36 PM
> Subject: SQL INSERTS - return ID
>
>
> > Anyone know a trick to return the ID of a record just Inserted into a
> table?
> >
> > Sincerely,
> >
> > Matthew M. Eschenbaum
> > Allaire Certified Professional
> > DevTech Inc.
> > [EMAIL PROTECTED]
> > 206.956.0888
> > www.dev-tech.com
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
