emp_id = Request.Querystring("emp_id")
Sql4="delete from send_mail where emp_id="& emp_id
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("test_project_update.mdb"))
set rs4=conn.execute(sql4)
Sql="delete from employee where emp_id="& emp_id
set rs=conn.execute(sql)
Sql2="delete from user where id="& emp_id
set rs2=conn.execute(sql2)
Sql3="delete from extra where id_extra="& emp_id
set rs3=conn.execute(sql3)
response.redirect "employee.asp"
%>
--------------------------------------------------------------------------------------------
relation คือ table emploeee เชื่อมกับ user ด้วย id
Tag : - - - -
Date :
26 ก.ค. 2551 23:08:21
By :
test
View :
1470
Reply :
1
No. 1
Guest
Code (ASP)
Sql2="delete from user where id="& emp_id
set rs2=conn.execute(sql2)
Load balance : Server 00
