http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-26T06:01:53 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/sql26.htm#16179 Here is one example:<br><cftransaction><br><br><cfquery name="qInsEmp" datasource="cfsnippets"><br>INSERT INTO Employees (FirstName,LastName,EMail,Phone,Department)<br>VALUES ('Simon', 'Horwith', 'SHORWITH','(202)-797-6570','Research and Development')<br></cfquery><br><br><cfquery name="qGetID" datasource="cfsnippets"><br>SELECT MAX(Emp_ID) AS New_Employee<br>FROM Employees<br></cfquery><br><br></cftransaction><br><br>For more information, see the article at http://www.macromedia.com/devnet/mx/coldfusion/articles/cftransaction.html. jrunrandy 1 1 2004-06-07T06:57:09 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/sql26.htm#16116 I would love to see an example!!! dorothee@tpg.com.au 0 0 2004-06-05T19:29:40