ASP 트랜잭션

<object runat="server" progid="ADODB.Connection" id="conn"></object>

 

<%

Response.Expires = -1
Response.AddHeader "Pragma", "no_cache"
Response.AddHeader "cache-control", "no_cache"

 

Const connStr = "Provider=SQLOLEDB.1;Initial Catalog=DBNAME;Data Source=ServerIP;User ID=DBID;PWD=DBPW"

conn.Open("connStr")

conn.BeginTrans

 

sql = "INSERT INTO tablename(a, b) values ('" & request("a") & "','" & request("b") & "')"
conn.execute sql

If conn.errors.count > 0 then

  conn.RollbackTrans    

   Response.write "<script language='javascript'>"&chr(13)
   Response.write " alert('데이터를 저장하는중 에러가 발생하였습니다.');"&chr(13)
   Response.write " history.back();"&chr(13)
   Response.write "</script>"&chr(13)
   conn.Close

   Response.end
Else

  conn.CommitTrans

   Response.write "<script language='javascript'>"&chr(13)
   Response.write " alert('데이터가 성공적으로 처리되었습니다.');"&chr(13)
   Response.write "</script>"&chr(13)
   conn.Close
End If
%>

youngsam