Possible to COMMIT an oracle database using ASP?

<i><b>Originally posted by : Martin Burford (mburford@hof.co.uk)</b></i><br />Can anyone help me with this request?<br /><br />I am writing data to an Oracle database using ADO and need to know how to commit the oracle table I am inserting data into everytime that data is sent to that table. This is because the web interface that the database is running off is constantly showing details that are no longer relevant (having been deleted or updated). A commit command would only save the latest version of the database, and thus would only ever be displaying the relevant live data<br /><br />Cheers for your help<br />Martin<br />

<i><b>Originally posted by : Erdal Kilinc (er_kilinc@hotmail.com)</b></i><br />Hi Martin,<br /><br />You can use commit property by using transactions when you work with ADO component.Write below code <br /><br /><%<br />Set Con = Server.CreateObject( "ADODB.Connection" )<br />Con.Open "FILE NAME=c:myDataLink.UDL;DATABASE=pubs"<br />Set RS = Server.CreateObject( "ADODB.Recordset" )<br />RS.CursorType = adOpenStatic<br />%><br /><br /><%<br />Sub insertRow<br />strsql = "insert into personel(Name,Dept,Sal) " _ <br /> & "values('" & Jim & "',10,1000)"<br /><br /> Rs.BeginTrans <br /> Rs.open strsql, con <br /> Rs.Commit <br />End Sub<br />%><br /><br /><br /><br /><br /><br /><br /><br /><br />------------<br />Martin Burford at 5/16/2000 9:49:34 AM<br /><br />Can anyone help me with this request?<br /><br />I am writing data to an Oracle database using ADO and need to know how to commit the oracle table I am inserting data into everytime that data is sent to that table. This is because the web interface that the database is running off is constantly showing details that are no longer relevant (having been deleted or updated). A commit command would only save the latest version of the database, and thus would only ever be displaying the relevant live data<br /><br />Cheers for your help<br />Martin<br />