If you are doing an "autonumber" type deal, just do the following
<insert stuff> <cfquery datasource="dsn" name="getid"> select MAX(id) from tablename </cfquery> That should do it for ya! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Kris Pilles" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 8:05 AM Subject: Query help > How can Insert a record into a table (that I know how to do) but after > the insert, I want to be able to know what the primary key for the > record I just inserted... > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists