<%@LANGUAGE="VBSCRIPT"%> <% Dim MM_editAction MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit Dim MM_abortEdit MM_abortEdit = false %> <% If (CStr(Request("MM_insert")) = "form1") Then If (Not MM_abortEdit) Then if cstr(session("checkcode")) <> cstr(request.form("txt_chk_code")) then 'response.Write(session("checkcode") & ","& request.form("txt_chk_code")) response.write("") response.end end if ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_conn_Count_STRING MM_editCmd.CommandText = "INSERT INTO Board (boardname, boardsubject, boardcontent, boardphoto) VALUES (?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("boardname")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("boardsubject")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 203, 1, 536870910, Request.Form("boardcontent")) ' adLongVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("RadioGroup1")) ' adVarWChar MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "05mb.aspx" If (Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If Response.Redirect(MM_editRedirectUrl) End If End If %> <% Dim Rec_Board Dim Rec_Board_cmd Dim Rec_Board_numRows Set Rec_Board_cmd = Server.CreateObject ("ADODB.Command") Rec_Board_cmd.ActiveConnection = MM_conn_Count_STRING Rec_Board_cmd.CommandText = "SELECT * FROM Board ORDER BY boardid DESC" Rec_Board_cmd.Prepared = true Set Rec_Board = Rec_Board_cmd.Execute Rec_Board_numRows = 0 %> NASA-WEDDING婚禮紀錄工作室
線上預約 網站地圖 與我們連絡
NASA-SOHO電腦多媒體工作室 製作維護


發言者
圖片預覽
TEST
標題
留言時間

留言祝福
祝福時
別忘了把新人名子寫上!!
檢驗驗證碼    
 
   






TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST
TEST

請留言票選小圖片


線上預約!


籌備中..近期上映!! iwedding婚禮記紀錄
<% Rec_Board.Close() Set Rec_Board = Nothing %>