<%@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 = "Location.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|box_Desktop|value|box_Notebook|value|box_Printers|value|box_Copiers|value|box_selectfax|value|box_Shredders|value|box_Projectors|value|box_Furniture|value|box_Dictating|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,''|Desktop|',none,''|fld_Note|',none,''|Printers|',none,''|Photocopiers|',none,''|Faxrent|',none,''|Shredders|',none,''|Proj|',none,''|Furniture|',none,''|Dictating|',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 ItemFrench 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 ItemFrench 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 ItemFrench 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 ItemFrench 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 ItemFrench 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 ItemFrench 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 ItemFrench 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 ItemFrench 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 ItemFrench 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 ItemFrench ASC" CatOthers.CursorType = 0 CatOthers.CursorLocation = 2 CatOthers.LockType = 1 CatOthers.Open() CatOthers_numRows = 0 %> Admaco - leader in sales, service and rentals of office equipment.

Pour recevoir une soumission pour une location, veuillez remplir le formulaire qui suit. Nous vous ferons parvenir rapidement toute l'information dont vous désirez.

 Compagnie :
Nom de la compagnie : Requis  
Contact : Requis  
Email : Requis  
Adresse :  
Ville :  
Province :  
# de téléphone : Requis  
# de fax :  
Durée du contrat :     
     
     
 Location :
Ordinateurs : Qty  
Ordinateurs portatifs : Qty  
Imprimantes : Qty  
Photocopieurs : Qty  
Fax : Qty  
Déchiquetteurs : Qty  
Projecteurs : Qty  
Mobilier de bureau : Qty  
Autres : Qty  
 Autres :
Commentaires ou questions :    
   
<% 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 %>