<%@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 ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_condizione_STRING MM_editCmd.CommandText = "INSERT INTO Customers (Nome, Cognome, IndirizzoPostaElettronica, Cittą, StatoOProvincia, CAP, Indirizzo, Telefono, InteressiContatto, Password) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("nome")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("cognome")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("email")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("cittą")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 20, Request.Form("Provincia")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 20, Request.Form("cap")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 255, Request.Form("Nazione")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 30, Request.Form("telefono")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 202, 1, 255, Request.Form("interessi")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 202, 1, 50, Request.Form("Password")) ' adVarWChar MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "../file/DIZIONE.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 Rsdizione Dim Rsdizione_cmd Dim Rsdizione_numRows Set Rsdizione_cmd = Server.CreateObject ("ADODB.Command") Rsdizione_cmd.ActiveConnection = MM_condizione_STRING Rsdizione_cmd.CommandText = "SELECT * FROM Customers" Rsdizione_cmd.Prepared = true Set Rsdizione = Rsdizione_cmd.Execute Rsdizione_numRows = 0 %>
www.cantarelopera.com
* campi obbligatori
Registrazione (i campi con asterisco * sono obbligatori)
Nome*/Ragione Sociale*
Cognome*
Email *
Città
Provincia
C.A.P.
Nazione*
Telefono
Ambito di interesse
(cantante, attore, giornalista, ecc..)
Scegli una password
Password*
 
 
 
 
privacy
<% Rsdizione.Close() Set Rsdizione = Nothing %>