Finding the Record-no after CFINSERT

[gbrownuk]

I've created a vehicle maintence cf database. On the new record page the user
enters the service details and then picks parts from a like that have been
replaced. When the submit button is pressed the action page creates a new
record in the MaintenceRecord table and then needs to know the record number
which will be added to each part record insertes into the PartsReplaced table.
On creating the primary key record in the MaintenceRecord table how do I read
it for use in the ReplacedParts table. Can the CFINSERT command return the
value. If I have to do a database QUERY other record may have been created
since my record was created and I'm worried I will not receive the correc value
and the ReplacedParts may appear againce another record.

Any help would be much appreciated.

Graham Brown

[The ScareCrow]

<cftransaction>
<cfinsert>
<cfquery name="getId">
Select Max(ID) As MaxId
From myTable
</cfquery>
</cftransaction>

The cftransaction ensures that both actions are performed together.
But if your using ms access 2k or above or ms sql you can use
<cftransaction>
<cfinsert>
<cfquery name="getId">
Select @@Identity As MaxId
From myTable
</cfquery>
</cftransaction>

Ken

[gbrownuk]

That's great, I can use that. Thankyou

Graham