sp1000je
58 lines
1.2 KiB
Plaintext
58 lines
1.2 KiB
Plaintext
<!--#include virtual = "/common/lib/dbcon.asp" -->
|
|
<!--#include virtual = "/common/lib/func.asp" -->
|
|
|
|
<!--#include file = "config.asp" -->
|
|
|
|
<%
|
|
|
|
' 파라미터정보 *************************************************************************************
|
|
poq_idx = InputValue(request("poq_idx"))
|
|
status = InputValue(request("status"))
|
|
' **************************************************************************************************
|
|
|
|
|
|
If status = "totdel" then ' 다중삭제
|
|
|
|
chk = request("chk")
|
|
arr_chk = Split(chk,",")
|
|
|
|
For z=0 To UBound(arr_chk)
|
|
|
|
sql = "select po_pk from poll_question where poq_idx= "&arr_chk(z)
|
|
Set Rs = Dbcon.Execute (sql)
|
|
If Not rs.eof Then
|
|
po_pk = rs(0)
|
|
End If
|
|
rs.close : Set rs = nothing
|
|
|
|
' poll_question 삭제
|
|
sql = " delete from poll_question where poq_idx = "&arr_chk(z)
|
|
Dbcon.execute sql
|
|
|
|
next
|
|
|
|
|
|
|
|
else' 일반삭제
|
|
|
|
|
|
sql = "select po_pk from poll_question where poq_idx= "&poq_idx
|
|
Set Rs = Dbcon.Execute (sql)
|
|
If Not rs.eof Then
|
|
po_pk = rs(0)
|
|
End If
|
|
rs.close : Set rs = Nothing
|
|
|
|
' poll_question 삭제
|
|
sql = " delete from poll_question where poq_idx = "&poq_idx
|
|
Dbcon.execute sql
|
|
|
|
End If
|
|
|
|
Dbcon.close
|
|
|
|
ok_url = "write_ui.asp?po_pk="&po_pk
|
|
Call loding ("0", ok_url)
|
|
|
|
|
|
%> |