%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% ' *** Edit Operations: declare variables MM_editAction = CStr(Request("URL")) 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")) <> "") Then MM_editConnection = MM_Admaco_STRING MM_editTable = "tbl_rent" MM_editRedirectUrl = "rental-success.asp" MM_fieldsStr = "box_name|value|box_contact|value|box_email|value|box_address|value|box_city|value|box_prov|value|box_Phone|value|box_Fax|value|box_Length|value|box_Ltype|value|QComputer|value|box_Desktop|value|QNotebook|value|box_Notebook|value|QPrinter|value|box_Printers|value|QCopier|value|box_Copiers|value|Qfax|value|box_selectfax|value|Qshred|value|box_Shredders|value|QProj|value|box_Projectors|value|Qfurn|value|box_Furniture|value|Qdic|value|box_Dictating|value|QOther|value|box_others|value|box_Comments|value" MM_columnsStr = "Company|',none,''|Contact|',none,''|Email|',none,''|Address|',none,''|City|',none,''|Province|',none,''|Phone|',none,''|Fax|',none,''|Length1|',none,''|Lenght2|',none,''|QDesktop|',none,''|Desktop|',none,''|QNote|',none,''|fld_Note|',none,''|QPrint|',none,''|Printers|',none,''|QPhoto|',none,''|Photocopiers|',none,''|QFax|',none,''|Faxrent|',none,''|QShred|',none,''|Shredders|',none,''|QProj|',none,''|Proj|',none,''|QFurn|',none,''|Furniture|',none,''|QDict|',none,''|Dictating|',none,''|QOthers|',none,''|Others|',none,''|Comments|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(i+1) = CStr(Request.Form(MM_fields(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 If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For i = LBound(MM_fields) To UBound(MM_fields) Step 2 FormVal = MM_fields(i+1) MM_typeArray = Split(MM_columns(i+1),",") Delim = MM_typeArray(0) If (Delim = "none") Then Delim = "" AltVal = MM_typeArray(1) If (AltVal = "none") Then AltVal = "" EmptyVal = MM_typeArray(2) If (EmptyVal = "none") Then EmptyVal = "" If (FormVal = "") Then FormVal = EmptyVal Else If (AltVal <> "") Then FormVal = AltVal ElseIf (Delim = "'") Then ' escape quotes FormVal = "'" & Replace(FormVal,"'","''") & "'" Else FormVal = Delim + FormVal + Delim End If End If If (i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End if MM_tableValues = MM_tableValues & MM_columns(i) MM_dbValues = MM_dbValues & 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 Desktop Dim Desktop_numRows Set Desktop = Server.CreateObject("ADODB.Recordset") Desktop.ActiveConnection = MM_Admaco_STRING Desktop.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Desktop Computer' Order by ItemEnglish ASC" Desktop.CursorType = 0 Desktop.CursorLocation = 2 Desktop.LockType = 1 Desktop.Open() Desktop_numRows = 0 %> <% Dim CatNotebook Dim CatNotebook_numRows Set CatNotebook = Server.CreateObject("ADODB.Recordset") CatNotebook.ActiveConnection = MM_Admaco_STRING CatNotebook.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Notebook computer' ORDER BY ItemEnglish ASC" CatNotebook.CursorType = 0 CatNotebook.CursorLocation = 2 CatNotebook.LockType = 1 CatNotebook.Open() CatNotebook_numRows = 0 %> <% Dim CatPrinters Dim CatPrinters_numRows Set CatPrinters = Server.CreateObject("ADODB.Recordset") CatPrinters.ActiveConnection = MM_Admaco_STRING CatPrinters.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Printer' ORDER BY ItemEnglish ASC" CatPrinters.CursorType = 0 CatPrinters.CursorLocation = 2 CatPrinters.LockType = 1 CatPrinters.Open() CatPrinters_numRows = 0 %> <% Dim CatPhoto Dim CatPhoto_numRows Set CatPhoto = Server.CreateObject("ADODB.Recordset") CatPhoto.ActiveConnection = MM_Admaco_STRING CatPhoto.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Photocopier' ORDER BY ItemEnglish ASC" CatPhoto.CursorType = 0 CatPhoto.CursorLocation = 2 CatPhoto.LockType = 1 CatPhoto.Open() CatPhoto_numRows = 0 %> <% Dim CatFax Dim CatFax_numRows Set CatFax = Server.CreateObject("ADODB.Recordset") CatFax.ActiveConnection = MM_Admaco_STRING CatFax.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Fax machine' ORDER BY ItemEnglish ASC" CatFax.CursorType = 0 CatFax.CursorLocation = 2 CatFax.LockType = 1 CatFax.Open() CatFax_numRows = 0 %> <% Dim CatShredder Dim CatShredder_numRows Set CatShredder = Server.CreateObject("ADODB.Recordset") CatShredder.ActiveConnection = MM_Admaco_STRING CatShredder.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Paper Shredder' ORDER BY ItemEnglish ASC" CatShredder.CursorType = 0 CatShredder.CursorLocation = 2 CatShredder.LockType = 1 CatShredder.Open() CatShredder_numRows = 0 %> <% Dim CatProjector Dim CatProjector_numRows Set CatProjector = Server.CreateObject("ADODB.Recordset") CatProjector.ActiveConnection = MM_Admaco_STRING CatProjector.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Projector' ORDER BY ItemEnglish ASC" CatProjector.CursorType = 0 CatProjector.CursorLocation = 2 CatProjector.LockType = 1 CatProjector.Open() CatProjector_numRows = 0 %> <% Dim CatFurniture Dim CatFurniture_numRows Set CatFurniture = Server.CreateObject("ADODB.Recordset") CatFurniture.ActiveConnection = MM_Admaco_STRING CatFurniture.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Office Furniture' ORDER BY ItemEnglish ASC" CatFurniture.CursorType = 0 CatFurniture.CursorLocation = 2 CatFurniture.LockType = 1 CatFurniture.Open() CatFurniture_numRows = 0 %> <% Dim CatDictating Dim CatDictating_numRows Set CatDictating = Server.CreateObject("ADODB.Recordset") CatDictating.ActiveConnection = MM_Admaco_STRING CatDictating.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Dictating machine' ORDER BY ItemEnglish ASC" CatDictating.CursorType = 0 CatDictating.CursorLocation = 2 CatDictating.LockType = 1 CatDictating.Open() CatDictating_numRows = 0 %> <% Dim CatOthers Dim CatOthers_numRows Set CatOthers = Server.CreateObject("ADODB.Recordset") CatOthers.ActiveConnection = MM_Admaco_STRING CatOthers.Source = "SELECT * FROM RentalForm WHERE EnglishCategory = 'Other' ORDER BY ItemEnglish ASC" CatOthers.CursorType = 0 CatOthers.CursorLocation = 2 CatOthers.LockType = 1 CatOthers.Open() CatOthers_numRows = 0 %>
|
To
receive a quote for a specific rental need, just fill out the information
below. You will quickly receive all the information you were looking
for. |
| We only cover the Montreal and surrounding areas. |
<% Desktop.Close() Set Desktop = Nothing %> <% CatNotebook.Close() Set CatNotebook = Nothing %> <% CatPrinters.Close() Set CatPrinters = Nothing %> <% CatPhoto.Close() Set CatPhoto = Nothing %> <% CatFax.Close() Set CatFax = Nothing %> <% CatShredder.Close() Set CatShredder = Nothing %> <% CatProjector.Close() Set CatProjector = Nothing %> <% CatFurniture.Close() Set CatFurniture = Nothing %> <% CatDictating.Close() Set CatDictating = Nothing %> <% CatOthers.Close() Set CatOthers = Nothing %>