<% captcha = true 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 %> <% If Request.Form.Count > 0 AND blnCAPTCHAcodeCorrect = false Then captcha = false If (CStr(Request("MM_insert")) = "friendform") AND blnCAPTCHAcodeCorrect Then If (Not MM_abortEdit) Then ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = application("CONNHL") MM_editCmd.CommandText = "INSERT INTO dbo.tbllinks (contactname, contactemail, linkurl, linkname, linkdescription, wherelink, siteid) VALUES (?, ?, ?, ?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 201, 1, 100, Request.Form("contactname")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 201, 1, 100, Request.Form("contactemail")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 100, Request.Form("linkurl")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 100, Request.Form("linkname")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 255, Request.Form("linkdescription")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 255, Request.Form("wherelink")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 5, 1, -1, MM_IIF(Request.Form("siteid"), Request.Form("siteid"), null)) ' adDouble MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "signedup.htm" 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 %>

Link Trade Signup Form

"/> A value is required.

" id="contactemail" type="text" size="30" /> A value is required.Valid Email address is required.


" id="linkurl" type="text" size="30" /> A value is required.Valid URL required, HTTP:// etc..


" id="linkname" type="text" size="30" /> A value is required.


" id="linkdescription" type="text" size="60" /> A value is required.


" size="60" />

 

<% if captcha = false then%> CAPTCHA CODE ENTERED WRONG, TRY AGAIN <%end if%>




" />