%@LANGUAGE="VBSCRIPT"%>
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers=""
MM_authFailedURL="login.asp"
MM_grantAccess=false
If Session("MM_Username") <> "" Then
If (true Or CStr(Session("MM_UserAuthorization"))="") Or _
(InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then
MM_grantAccess = true
End If
End If
If Not MM_grantAccess Then
MM_qsChar = "?"
If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&"
MM_referrer = Request.ServerVariables("URL")
if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString()
MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer)
Response.Redirect(MM_authFailedURL)
End If
%>
<%
If Request("sign_id") = "" Then
Response.Redirect("admin.asp")
End If
%>
<%
SignID = Request("sign_id")
'Manage = Request("manage")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open(MM_cotec_STRING)
sql = "Select * From signData Where sign_id = " & SignID
Set rs = conn.Execute(sql)
sqlno = "Select max(pono) as ponomax From signData"
Set rsno = conn.Execute(sqlno)
dim ponos,ponomaxs,ponomaxss,ponomaxrp
ponos = rs("pono")
ponomaxs = rsno("ponomax")
If Not IsNull(ponos) Then
ponomaxrp = left("00000",5-len(ponos)) & ponos
Else
ponomaxrp = ""
End If
If IsNull(ponomaxs) then
ponomaxss = "00001"
Else
ponomaxss = rsno("ponomax") +1
ponomaxss = left("00000",5-len(Cstr(ponomaxss))) & ponomaxss
End If
%>
報名修改
報名修改:
<% If IsNull(rs("company")) Then Response.Write("") Else Response.Write(rs("company")) End If%>