%@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 %> <% ' IIf implementation Function MM_IIf(condition, ifTrue, ifFalse) If condition = "" Then MM_IIf = ifFalse Else MM_IIf = ifTrue End If End Function %> <% On Error Resume Next %> <% If (CStr(Request("MM_insert")) = "form1") Then If (Not MM_abortEdit) Then ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_ESAIC_STRING MM_editCmd.CommandText = "INSERT INTO Registrazione (Username, Password, Nome, Cognome, Email, Sesso, Data_Nascita, Paese, Titolo_Studio, Stato_Civile, Figli, Privacy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 15, Request.Form("login")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 15, Request.Form("passw")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("nome")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("cognome")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 200, Request.Form("email")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 15, Request.Form("sex")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 135, 1, -1, MM_IIF(Request.Form("data_n"), Request.Form("data_n"), null)) ' adDBTimeStamp MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 150, Request.Form("citta")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 202, 1, 150, Request.Form("TITOLOS")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 202, 1, 150, Request.Form("STATOC")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 202, 1, 50, Request.Form("FIGLI")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 202, 1, 50, Request.Form("privac")) ' adVarWChar MM_editCmd.Execute MM_editCmd.ActiveConnection.Close 'gestione errori if Err.Number <>0 Then Response.Clear() Response.Redirect("err_reg.asp") end if ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "benvenuto.asp" 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 FIGLI Dim FIGLI_cmd Dim FIGLI_numRows Set FIGLI_cmd = Server.CreateObject ("ADODB.Command") FIGLI_cmd.ActiveConnection = MM_ESAIC_STRING FIGLI_cmd.CommandText = "SELECT * FROM FIGLI" FIGLI_cmd.Prepared = true Set FIGLI = FIGLI_cmd.Execute FIGLI_numRows = 0 %> <% Dim STATOC Dim STATOC_cmd Dim STATOC_numRows Set STATOC_cmd = Server.CreateObject ("ADODB.Command") STATOC_cmd.ActiveConnection = MM_ESAIC_STRING STATOC_cmd.CommandText = "SELECT * FROM STATOC" STATOC_cmd.Prepared = true Set STATOC = STATOC_cmd.Execute STATOC_numRows = 0 %><% Dim TITOLOS Dim TITOLOS_cmd Dim TITOLOS_numRows Set TITOLOS_cmd = Server.CreateObject ("ADODB.Command") TITOLOS_cmd.ActiveConnection = MM_ESAIC_STRING TITOLOS_cmd.CommandText = "SELECT * FROM TITOLOS" TITOLOS_cmd.Prepared = true Set TITOLOS = TITOLOS_cmd.Execute TITOLOS_numRows = 0 %> <% Dim sex Dim sex_cmd Dim sex_numRows Set sex_cmd = Server.CreateObject ("ADODB.Command") sex_cmd.ActiveConnection = MM_ESAIC_STRING sex_cmd.CommandText = "SELECT * FROM SESSO" sex_cmd.Prepared = true Set sex = sex_cmd.Execute sex_numRows = 0 %>
![]() |
![]() |
![]() |
![]() |
||