<%@LANGUAGE="VBSCRIPT"%> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Request.QueryString End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_WebData_STRING MM_editTable = "NewsletterContacts" MM_editRedirectUrl = "RegistrationSuccessful.asp?Last=" & Request("LastName") & "&First=" & Request("FirstName") & "&Addr=" & Request("EmailAddress") MM_fieldsStr = "FirstName|value|LastName|value|EmailAddress|value|HomeAddress|value|HomeCity|value|HomeState|value|HomeZipcode|value|HowFound|value|UserCategory|value|DateRegistered|value" MM_columnsStr = "FirstName|',none,''|LastName|',none,''|EmailAddress|',none,''|HomeAddress|',none,''|HomeCity|',none,''|HomeState|',none,''|HomeZipcode|',none,''|HowFound|',none,''|UserCategory|',none,''|DateRegistered|',none,NULL" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% Dim HowFound Dim HowFound_numRows Set HowFound = Server.CreateObject("ADODB.Recordset") HowFound.ActiveConnection = MM_WebData_STRING HowFound.Source = "SELECT * FROM HowFoundUs" HowFound.CursorType = 0 HowFound.CursorLocation = 2 HowFound.LockType = 1 HowFound.Open() HowFound_numRows = 0 %> <% Dim VisitorType Dim VisitorType_numRows Set VisitorType = Server.CreateObject("ADODB.Recordset") VisitorType.ActiveConnection = MM_WebData_STRING VisitorType.Source = "SELECT * FROM TypeOfVisitor" VisitorType.CursorType = 0 VisitorType.CursorLocation = 2 VisitorType.LockType = 1 VisitorType.Open() VisitorType_numRows = 0 %> The Complete Guide to Financing College and Admissions

The Complete Guide to Financing College and Admissions
Home  | Learn More |  Results |  Testimonials  |  Order  |  About Mr. Wilfong |  CD Updates  |  Partners in Education |  Contact Us

Register for a free monthly email

If you would like to receive a free monthly news letter containing valuable tips and money saving ideas, please register below.

We do not distribute, lease, or sell your email address or other information to any third parties; however, CollegeOptions.net may periodically email you valuable information regarding program updates or upcoming speaking engagements.  (If you wish to be removed from our email list at any time, simply send an email to admin@collegeoptions.net with "Remove" in the subject line.)

The newsletter will be in .pdf format which requires Adobe Reader.  If you do not already have Adobe Reader, you may receive a free download of the program by clicking the Adobe logo below.
First Name: *
Last Name: *
Email Address: *
Address:
City:
State:
Zip Code:
How did you find out about us?
Type of Visitor:
* - Required Information
 

If you have trouble registering for the newsletter, please check your system/network security configuration to make sure the ability to send your information has not been blocked. If you experience any trouble registering for the newsletter, please contact admin@collegeoptions.net.

 

www.collegeoptions.net | Copyright 2005-2008 | All Rights Reserved
 
<% HowFound.Close() Set HowFound = Nothing %> <% VisitorType.Close() Set VisitorType = Nothing %>