the max id thing will work if noone else enters any information between when
you submit the id and query to get the maxid you can also get the id by
querying the database for all of the other values you put in if you know
this this is the best way
Select *
FROM tablename
WHERE value1 = form.val1 and this= this and this = this and so on then you
can p[rint out the id or use it
----- Original Message -----
From: "Dan" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, October 30, 2000 7:25 PM
Subject: Record ID
> Hi, Can anyone help me identify the Record ID of a record that was just
> CFINSERTed into an Access Database where RecordID is an Autonumber field?
>
> I've tried cfquery the table using a date&time variable (Where
> DateCreated='#Form.DateCreated#') to get the ID but the form date is
> different than the date coming back from Access.
>
> Maybe I shouldn't be using AutoNumbers but setting up a control counter
> instead.
>
> This has to be a pretty simple task.
>
> --------------------------------------------------------------------------
----
> To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
>
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
