<%@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 & "?" & Server.HTMLEncode(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_ownerfinanced_STRING MM_editTable = "HomePreferences" MM_editRedirectUrl = "" MM_fieldsStr = "FirstName|value|LastName|value|Email|value|Phone|value|Fax|value|ContactMethod|value|MaxDPAmt|value|MaxLeaseAmt|value|Bedrooms|value|Bathrooms|value|SqFeet|value|Stories|value|Garages|value|ConditionHome|value|AreaTown|value|Comments|value|Type|value" MM_columnsStr = "FirstName|',none,''|LastName|',none,''|Email|',none,''|Phone|',none,''|Fax|',none,''|ContactMethod|',none,''|MaxDPAmt|',none,''|MaxLeaseAmt|',none,''|Bedrooms|none,none,NULL|Bathrooms|none,none,NULL|SqFeet|',none,''|Stories|',none,''|Garages|none,none,NULL|ConditionHome|',none,''|AreaTown|',none,''|Comments|',none,''|Type|',none,''" ' 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 %> <% function WA_Universal_Email_1_SendMail(RecipientEmail) dim MailObject, MailAttachments, MailBCC, MailCC, MailTo, MailBodyFormat, MailBody, MailImportance, MailFrom, MailSubject MailAttachments = "" MailBCC = "" MailCC = "" MailTo = "" MailBodyFormat = "" MailBody = "" MailImportance = "" MailFrom = "" & cStr(cStr(Request.Form("Email"))) & "" MailSubject = "New Home Preference Submission" 'Global Variables gBodyFormat = "" set WA_MailObject = WAUE_Definition("takeovermyhousepayment.com","25","chestnut@takeovermyhousepayment.com","ivcPRO") if (RecipientEmail <> "") then set WA_MailObject = WAUE_AddRecipient(WA_MailObject,RecipientEmail) else 'To Entries end if 'Attachment Entries 'BCC Entries 'CC Entries 'Body Format set WA_MailObject = WAUE_BodyFormat(WA_MailObject,1) MailBodyFormat = gBodyFormat 'Set Importance set WA_MailObject = WAUE_SetImportance(WA_MailObject,"1") 'Start Mail Body MailBody = MailBody & "Hi Lamont," & vbCrlf & "" MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "You have received a new 'Home Preferences' submission, containing the following information:" & vbCrlf & "" MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Personal Information" & vbCrlf & "" MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "First Name: " MailBody = MailBody & cStr(Request.Form("FirstName")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Last Name: " MailBody = MailBody & cStr(Request.Form("LastName")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Email Address: " MailBody = MailBody & cStr(Request.Form("Email")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Phone: " MailBody = MailBody & cStr(Request.Form("Phone")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Fax: " MailBody = MailBody & cStr(Request.Form("Fax")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Preferred Contact Method: " MailBody = MailBody & cStr(Request.Form("ContactMethod")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Home Specifications " & vbCrlf & "" MailBody = MailBody & "Maximum Down Payment of: $ " MailBody = MailBody & cStr(Request.Form("MaxDPAmt")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Maximum Monthly Lease of: $ " MailBody = MailBody & cStr(Request.Form("MaxLeaseAmt")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "# of Bedrooms: " MailBody = MailBody & cStr(Request.Form("Bedrooms")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "# of Bathrooms: " MailBody = MailBody & cStr(Request.Form("Bathrooms")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "# of Square Feet: " MailBody = MailBody & cStr(Request.Form("SqFeet")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "# of Stories: " MailBody = MailBody & cStr(Request.Form("Stories")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "# of Garages: " MailBody = MailBody & cStr(Request.Form("Garages")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Preferred Condition of Home: " MailBody = MailBody & cStr(Request.Form("ConditionHome")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Preferred Area of Town: " MailBody = MailBody & cStr(Request.Form("AreaTown")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Additional Comments: " MailBody = MailBody & cStr(Request.Form("Comments")) MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "Sincerely," & vbCrlf & "" MailBody = MailBody & "" & vbCrlf & "" MailBody = MailBody & "The Owner Financed Homes of Houston website" 'End Mail Body set WA_MailObject = WAUE_SendMail(WA_MailObject,MailAttachments,MailBCC,MailCC,MailTo,MailImportance,MailFrom,MailSubject,MailBody) set WA_MailObject = nothing end function %> <% if ((cStr(Request.Form("Submit")) <> "")) then 'WA Universal Email object="AspEmail" 'Send Loop Once Per Entry WA_Universal_Email_1_SendMail("lchestnut@takeovermyhousepayment.com") 'Send Mail All Entries if ("index07.asp"<>"") then Response.Redirect("index07.asp") end if end if %> Owner Financed Homes of Houston

Please fill out the following form in it's entirety. If you have any questions, please Send Us An Email.

My New Home Preferences
Personal Information
First Name: *
Last Name: *
Email Address: *
Confirm Email: *
Phone: *
Fax:
Preferred Contact Method: *
   
Home Specifications
Maximum Down Payment $ *
Maximum Monthly Lease of $ *
# of Bedrooms *
# of Bathrooms *
# of Square Feet *
# of Stories *
# of Garages *
Preferred Condition of Home*
Preferred Area of Town*
(hold down CTRL to select multiple areas)

Additional Comments:



© 2005 Owner Financed Homes of Houston. All rights reserved