<%@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")) = "Subcontractor") Then MM_editConnection = MM_Contr_STRING MM_editTable = "cont" MM_editRedirectUrl = "home.html" MM_fieldsStr = "Company|value|employees|value|Sales|value|address|value|city|value|Zipcode|value|state|value|phone|value|fax|value|Contact|value|email|value|Webpage|value|Market|value|architecture|value|airport|value|bridgestunnels|value|cable|value|carpentry|value|concretepaving|value|constmang|value|conststeel|value|conssupplies|value|demolition|value|roofing|value|drywall|value|electrical|value|enviromental|value|erosioncontrol|value|excavation|value|fencing|value|fireprotec|value|hvac|value|gasoil|value|generalconst|value|generalcont|value|grading|value|granitemarble|value|hauling|value|heavyconst|value|hydraulics|value|landscaping|value|renovations|value|piping|value|plumbing|value|pngservices|value|utilities|value|watersewer|value|masonry|value|other|value|agency1|value|certnum1|value|expiration1|value|Type1|value|agency2|value|certnum2|value|expiration2|value|type2|value|agency3|value|certnum3|value|expiration3|value|type3|value|agency4|value|certnum4|value|expiration4|value|type4|value|agency5|value|certnum5|value|expiration5|value|type5|value|minority|value|bonded|value|bondinglimit|value|yearsinbiz|value|Custom1|value|description1|value|location1|value|value1|value|date1|value|custom2|value|description2|value|location2|value|value2|value|date2|value|custom3|value|description3|value|location3|value|value3|value|date3|value|custom4|value|description4|value|location4|value|value4|value|date4|value|comments|value|areas|value" MM_columnsStr = "name|',none,''|employees|',none,''|sales|',none,''|address|',none,''|city|',none,''|zipcode|none,none,NULL|state|',none,''|phone|',none,''|fax|',none,''|contact|',none,''|email|',none,''|webpage|',none,''|market|',none,''|ArchictureEngineering|none,1,0|AirportServices|none,1,0|BridgesTunnels|none,1,0|CableServices|none,1,0|Carpentry|none,1,0|ConcretePaving|none,1,0|ConstructionManagement|none,1,0|ConstructionSteel|none,1,0|ConstructionSupplies|none,1,0|Demolition|none,1,0|Roofing|none,1,0|Drywall|none,1,0|ElectricalContracting|none,1,0|EnviromentalConsultant|none,1,0|ErosionControl|none,1,0|Excavation|none,1,0|Fencing|none,1,0|FireProtection|none,1,0|HVAC|none,1,0|GasOil|none,1,0|GeneralConstruction|none,1,0|GeneralContracting|none,1,0|Grading|none,1,0|GraniteMarbleDesign|none,1,0|Hauling|none,1,0|HeavyConstruction|none,1,0|Hydraulics|none,1,0|Landscape|none,1,0|Renovations|none,1,0|PipelayingPiping|none,1,0|Plumbing|none,1,0|ProfesionalnGeneralServices|none,1,0|UtilitiesConstruction|none,1,0|WaterSewer|none,1,0|Masonry|none,1,0|Other|none,1,0|agency1|',none,''|certnum1|',none,''|expiration1|',none,''|type1|',none,''|agency2|',none,''|certnum2|',none,''|expiration2|',none,''|type2|',none,''|agency3|',none,''|certnum3|',none,''|expiration3|',none,''|type3|',none,''|agency4|',none,''|certnum4|',none,''|expiration4|',none,''|type4|',none,''|agency5|',none,''|certnum5|',none,''|expiration5|',none,''|type5|',none,''|notminority|none,1,0|bonded|none,1,0|bondlimit|',none,''|years|',none,''|costumer1|',none,''|wdescrp1|',none,''|location1|',none,''|value1|',none,''|date1|',none,''|costumer2|',none,''|wdescrp2|',none,''|location2|',none,''|value2|',none,''|date2|',none,''|costumer3|',none,''|wdescrp3|',none,''|location3|',none,''|value3|',none,''|date3|',none,''|costumer4|',none,''|wdescrp4|',none,''|location4|',none,''|value4|',none,''|date4|',none,''|comments|',none,''|area|',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 %> Precision 2000, Inc. - Partners

 

__Partners

 

Home

Company

Projects

Awards & Memberships

Organization

News

Contact

 

Precision 2000, Inc. operates as a General Contractor in various markets. The company uses trade subcontractors for a portion of the project and self-performes other parts. For this reason is important to have an extensive database of subcontractors and vendors so that we can select the appropriate resources for a project according to their areas of expertise and skills. Choosing the right subcontractors and vendors is a key element to the success of the project and the quality of the work performed. For this reason, Precision 2000, Inc. evaluates carefully every company hired to be able to deliver to their clients a quality project.

If your company is interested in working as a trade contractor with Precision 2000, Inc., please complete the enclosed form.

Top

Subcontractors

Some of the subcontractors that have been used in our projects are:

  • Cowart Tree Experts Inc.
  • Eagle Grooving and Grinding
  • Engineering Restoration Inc.
  • Engitek
  • Environmental Solutions ESI
  • James Hightower Trucking
  • JRK Trucking
  • Kemi Construction Co.
  • Knight & Associates
  • Multi Works
  • Q-B Engineering
  • Southern Wilderness
  • Teberco
  • Thrasher Trucking
  • Trinidad Engineering
  • VECO
  • TMC Grassing

 

Top

 

Registration Form

If you are interested in work with us, please take a moment and fill out the next form or download the file and mail it to us.

Fill form online

Download form

 

Top