<%@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 %> <% If (CStr(Request("MM_insert")) = "RFQ") Then If (Not MM_abortEdit) Then ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_connLightningMobile_STRING MM_editCmd.CommandText = "INSERT INTO RFQs (Name, Company, Phone, Email, Fax, BestTimeToCall, WorkSiteAddress, RFQTypeID, ProjectDescription) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("Your name")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("Company name")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("Phone number")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("Your e-mail address")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 50, Request.Form("Fax number")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 202, 1, 50, Request.Form("Best time to call")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 150, Request.Form("Work site address")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 5, 1, -1, MM_IIF(Request.Form("Project type"), Request.Form("Project type"), null)) ' adDouble MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 203, 1, 1073741823, Request.Form("Your project description")) ' adLongVarWChar MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "RFQ-ThankYou.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 rsRFQTypeMenu Dim rsRFQTypeMenu_cmd Dim rsRFQTypeMenu_numRows Set rsRFQTypeMenu_cmd = Server.CreateObject ("ADODB.Command") rsRFQTypeMenu_cmd.ActiveConnection = MM_connLightningMobile_STRING rsRFQTypeMenu_cmd.CommandText = "SELECT * FROM RFQTypes ORDER BY MenuDisplayID ASC" rsRFQTypeMenu_cmd.Prepared = true Set rsRFQTypeMenu = rsRFQTypeMenu_cmd.Execute rsRFQTypeMenu_numRows = 0 %>

Request A Quote Please call (303) 595-9559 or use our quote request form to get a free quote for your landscaping, snow removal, pressure washing, sandblasting, window cleaning or any other exterior maintenance project. (* Indicates a required field)   Your Name:* Company Name:*   Phone Number:* E-mail Address:*   Fax Number:* * Best time for us to call you: *   Street address for the work site: *   Type of project: * <% While (NOT rsRFQTypeMenu.EOF) %> "><%=(rsRFQTypeMenu.Fields.Item("RFQType").Value)%> <% rsRFQTypeMenu.MoveNext() Wend If (rsRFQTypeMenu.CursorType > 0) Then rsRFQTypeMenu.MoveFirst Else rsRFQTypeMenu.Requery End If %>   Please describe your project to us in as much detail as possible:*     Our Privacy Policy Lightning Mobile, Inc. respects your privacy. Contact information submitted on this web site is used for business-to-business contact purposes only. Lightning Mobile will not share your contact information with any third parties or use it for any commercial purpose.

HOME   |   OUR SERVICES   |   REQUEST A QUOTE   |   EMPLOYMENT OPPORTUNITITES   |   CONTACT US

Lightning Mobile, Inc.  |   Denver's Leading Exterior Maintenance Service Provider

260 E. 54th Ave, Denver, CO 80216   |   (303) 595-9559   |   Fax: (303) 620-9258

© 2007-2009 Lightning Mobile, Inc.  |  Site by Web Equilibrium

<% rsRFQTypeMenu.Close() Set rsRFQTypeMenu = Nothing %>