% startup_id = request.querystring("sid") if request.form("submit") = "Submit" then 'sql = "declare @startup_id int exec up_new_startup " & dist_id & ",@startup_id output select @startup_id" dt = Now() sql = "insert into startup (dist_id) values(" & dist_id & ")" conn.Execute(Sql) sql = "select max(startup_id) from startup where dist_id = " & dist_id set rs = conn.Execute(sql) startup_id = rs(0) blnUpdate = true elseif request.form("submit") = "Update" then blnUpdate = true Dt = CheckString(request.form("Date")) end if if blnUpdate then Performed_By = CheckString(request.form("Performed_By")) Customer_Name = CheckString(request.form("Customer_Name")) Installation_Location = CheckString(request.form("Installation_Location")) Model_Number = CheckString(request.form("Model_Number")) Serial_Number = CheckString(request.form("Serial_Number")) Genset_Placement_Indoor = CheckBit(request.form("Genset_Placement_Indoor")) Genset_Placement_Outdoor = CheckBit(request.form("Genset_Placement_Outdoor")) App_Continuous_Standby = CheckBit(request.form("App_Continuous_Standby")) App_Prime_Power = CheckBit(request.form("App_Prime_Power")) App_Other = CheckBit(request.form("App_Other")) App_Other_text = CheckString(request.form("App_Other_text")) PS_Oil_Level = CheckBit(request.form("PS_Oil_Level")) PS_Radiator_Fluid_Level = CheckBit(request.form("PS_Radiator_Fluid_Level")) PS_Battery_Fluid_Level = CheckBit(request.form("PS_Battery_Fluid_Level")) PS_Ventiation = CheckBit(request.form("PS_Ventiation")) PS_Belts_Hoses_Tight = CheckBit(request.form("PS_Belts_Hoses_Tight")) PS_Main_Output_Leads = CheckBit(request.form("PS_Main_Output_Leads")) PS_Remote_Start_Leads = CheckBit(request.form("PS_Remote_Start_Leads")) PS_Fuel_Line = CheckBit(request.form("PS_Fuel_Line")) PS_Remote_Annunciator = CheckBit(request.form("PS_Remote_Annunciator")) PS_Unit_Grounded = CheckBit(request.form("PS_Unit_Grounded")) PS_Location = CheckString(request.form("PS_Location")) SU_Main_Breaker_Off = CheckBit(request.form("SU_Main_Breaker_Off")) SU_Reset_Control_Breakers = CheckBit(request.form("SU_Reset_Control_Breakers")) SU_Bleed_Fuel_Lines = CheckBit(request.form("SU_Bleed_Fuel_Lines")) SU_Connect_Battery = CheckBit(request.form("SU_Connect_Battery")) SU_Start_Unit = CheckBit(request.form("SU_Start_Unit")) SU_Check_For_Noise = CheckBit(request.form("SU_Check_For_Noise")) SU_Check_Oil_Pressure = CheckBit(request.form("SU_Check_Oil_Pressure")) SU_Check_Oil_Pressure_val = CheckString(request.form("SU_Check_Oil_Pressure_val")) SU_Water_Temp = CheckBit(request.form("SU_Water_Temp")) SU_Water_Temp_val = CheckString(request.form("SU_Water_Temp_val")) SU_DC_Voltage = CheckBit(request.form("SU_DC_Voltage")) SU_DC_Voltage_val = CheckString(request.form("SU_DC_Voltage_val")) SU_AC_Voltage = CheckBit(request.form("SU_AC_Voltage")) SU_AC_Voltage_val = CheckString(request.form("SU_AC_Voltage_val")) SU_AC_Frequency = CheckBit(request.form("SU_AC_Frequency")) SU_AC_Frequency_val = CheckString(request.form("SU_AC_Frequency_val")) FS_Ground_Oil_Pressure_Sensor = CheckBit(request.form("FS_Ground_Oil_Pressure_Sensor")) FS_Ground_High_Engine_Temp = CheckBit(request.form("FS_Ground_High_Engine_Temp")) FS_Oil_Pressure = CheckBit(request.form("FS_Oil_Pressure")) FS_Oil_Pressure_val = CheckString(request.form("FS_Oil_Pressure_val")) FS_Water_Temp = CheckBit(request.form("FS_Water_Temp")) FS_Water_Temp_val = CheckString(request.form("FS_Water_Temp_val")) FS_DC_Volts = CheckBit(request.form("FS_DC_Volts")) FS_DC_Volts_val = CheckString(request.form("FS_DC_Volts_val")) AO_Turn_Main_Breaker_On = CheckBit(request.form("AO_Turn_Main_Breaker_On")) AO_Set_ATS_To_TI = CheckBit(request.form("AO_Set_ATS_To_TI")) AO_Start_GenSet = CheckBit(request.form("AO_Start_GenSet")) AO_Check_Rotation_At_ATS = CheckBit(request.form("AO_Check_Rotation_At_ATS")) AO_Set_To_Auto_Position = CheckBit(request.form("AO_Set_To_Auto_Position")) AO_Stimulate_Outage = CheckBit(request.form("AO_Stimulate_Outage")) AO_Voltage_Phase_1 = CheckBit(request.form("AO_Voltage_Phase_1")) AO_Voltage_Phase_1_val = CheckString(request.form("AO_Voltage_Phase_1_val")) AO_Amps_Phase_1 = CheckBit(request.form("AO_Amps_Phase_1")) AO_Amps_Phase_1_val = CheckString(request.form("AO_Amps_Phase_1_val")) AO_Voltage_Phase_2 = CheckBit(request.form("AO_Voltage_Phase_2")) AO_Voltage_Phase_2_val = CheckString(request.form("AO_Voltage_Phase_2_val")) AO_Amps_Phase_3 = CheckBit(request.form("AO_Amps_Phase_3")) AO_Amps_Phase_3_val = CheckString(request.form("AO_Amps_Phase_3_val")) AO_Voltage_Phase_4 = CheckBit(request.form("AO_Voltage_Phase_4")) AO_Voltage_Phase_4_val = CheckString(request.form("AO_Voltage_Phase_4_val")) AO_Amps_Phase_4 = CheckBit(request.form("AO_Amps_Phase_4")) AO_Amps_Phase_4_val = CheckString(request.form("AO_Amps_Phase_4_val")) AO_Frequency_Under_Load = CheckBit(request.form("AO_Frequency_Under_Load")) AO_Frequency_Under_Load_val = CheckString(request.form("AO_Frequency_Under_Load_val")) AO_Oil_Pressure = CheckBit(request.form("AO_Oil_Pressure")) AO_Oil_Pressure_val = CheckString(request.form("AO_Oil_Pressure_val")) AO_Engine_Temp = CheckBit(request.form("AO_Engine_Temp")) AO_Engine_Temp_val = CheckString(request.form("AO_Engine_Temp_val")) AO_Check_For_Noise = CheckBit(request.form("AO_Check_For_Noise")) AO_Check_For_Noise_val = CheckString(request.form("AO_Check_For_Noise_val")) AO_Time_Delay_To_retransfer = CheckBit(request.form("AO_Time_Delay_To_retransfer")) AO_Time_Delay_To_retran_val = CheckString(request.form("AO_Time_Delay_To_retran_val")) AO_Cool_Down_Time_Delay = CheckBit(request.form("AO_Cool_Down_Time_Delay")) AO_Cool_Down_Time_Delay_val = CheckString(request.form("AO_Cool_Down_Time_Delay_val")) AT_Make = CheckString(request.form("AT_Make")) AT_Model_Number = CheckString(request.form("AT_Model_Number")) AT_Serial_Number = CheckString(request.form("AT_Serial_Number")) AT_Two_Pole = CheckBit(request.form("AT_Two_Pole")) AT_Three_Pole = CheckBit(request.form("AT_Three_Pole")) AT_Four_Pole = CheckBit(request.form("AT_Four_Pole")) AT_Open = CheckBit(request.form("AT_Open")) AT_NEMA = CheckBit(request.form("AT_NEMA")) AT_NEMA_3R = CheckBit(request.form("AT_NEMA_3R")) AT_Other = CheckBit(request.form("AT_Other")) AT_Other_val = CheckString(request.form("AT_Other_val")) BC_Make = CheckString(request.form("BC_Make")) BC_Model = CheckString(request.form("BC_Model")) BC_Amp_Rating = CheckString(request.form("BC_Amp_Rating")) Running_Time_Meter_Reading = CheckBit(request.form("Running_Time_Meter_Reading")) Running_Time_Meter_val = CheckString(request.form("Running_Time_Meter_val")) Suggestions = CheckString(request.form("Suggestions")) Completed_By = CheckString(request.form("Completed_By")) Completed_Date = CheckString(request.form("Completed_Date")) sql = "update startup set Performed_By = '" & Performed_By & "',entry_date = '" & FormatDT(Dt) & "',Customer_Name = '" & Customer_Name & "',Installation_Location = '" & Installation_Location & "',Model_Number = '" & Model_Number & "',Serial_Number = '" & Serial_Number & "',Genset_Placement_Indoor = " & Genset_Placement_Indoor & ",Genset_Placement_Outdoor = " & Genset_Placement_Outdoor & ",App_Continuous_Standby = " & App_Continuous_Standby & ",App_Prime_Power = " & App_Prime_Power & ",App_Other = " & App_Other & ",App_Other_text = '" & App_Other_text & "',PS_Oil_Level = " & PS_Oil_Level & ",PS_Radiator_Fluid_Level = " & PS_Radiator_Fluid_Level & ",PS_Battery_Fluid_Level = " & PS_Battery_Fluid_Level & ",PS_Ventiation = " & PS_Ventiation & ",PS_Belts_Hoses_Tight = " & PS_Belts_Hoses_Tight & ",PS_Main_Output_Leads = " & PS_Main_Output_Leads & ",PS_Remote_Start_Leads = " & PS_Remote_Start_Leads & ",PS_Fuel_Line = " & PS_Fuel_Line & ",PS_Remote_Annunciator = " & PS_Remote_Annunciator & ",PS_Unit_Grounded = " & PS_Unit_Grounded & ",PS_Location = '" & PS_Location & "',SU_Main_Breaker_Off = " & SU_Main_Breaker_Off & ",SU_Reset_Control_Breakers = " & SU_Reset_Control_Breakers & ",SU_Bleed_Fuel_Lines = " & SU_Bleed_Fuel_Lines & ",SU_Connect_Battery = " & SU_Connect_Battery & ",SU_Start_Unit = " & SU_Start_Unit & ",SU_Check_For_Noise = " & SU_Check_For_Noise & ",SU_Check_Oil_Pressure = " & SU_Check_Oil_Pressure & ",SU_Check_Oil_Pressure_val = '" & SU_Check_Oil_Pressure_val & "',SU_Water_Temp = " & SU_Water_Temp & ",SU_Water_Temp_val = '" & SU_Water_Temp_val & "',SU_DC_Voltage = " & SU_DC_Voltage & ",SU_DC_Voltage_val = '" & SU_DC_Voltage_val & "',SU_AC_Voltage = " & SU_AC_Voltage & ",SU_AC_Voltage_val = '" & SU_AC_Voltage_val & "',SU_AC_Frequency = " & SU_AC_Frequency & ",SU_AC_Frequency_val = '" & SU_AC_Frequency_val & "',FS_Ground_Oil_Pressure_Sensor = " & FS_Ground_Oil_Pressure_Sensor & ",FS_Ground_High_Engine_Temp = " & FS_Ground_High_Engine_Temp & ",FS_Oil_Pressure = " & FS_Oil_Pressure & ",FS_Oil_Pressure_val = '" & FS_Oil_Pressure_val & "',FS_Water_Temp = " & FS_Water_Temp & ",FS_Water_Temp_val = '" & FS_Water_Temp_val & "',FS_DC_Volts = " & FS_DC_Volts & ",FS_DC_Volts_val = '" & FS_DC_Volts_val & "',AO_Turn_Main_Breaker_On = " & AO_Turn_Main_Breaker_On & ",AO_Set_ATS_To_TI = " & AO_Set_ATS_To_TI & ",AO_Start_GenSet = " & AO_Start_GenSet & ",AO_Check_Rotation_At_ATS = " & AO_Check_Rotation_At_ATS & ",AO_Set_To_Auto_Position = " & AO_Set_To_Auto_Position & ",AO_Stimulate_Outage = " & AO_Stimulate_Outage & ",AO_Voltage_Phase_1 = " & AO_Voltage_Phase_1 & ",AO_Voltage_Phase_1_val = '" & AO_Voltage_Phase_1_val & "',AO_Amps_Phase_1 = " & AO_Amps_Phase_1 & ",AO_Amps_Phase_1_val = '" & AO_Amps_Phase_1_val & "',AO_Voltage_Phase_2 = " & AO_Voltage_Phase_2 & ",AO_Voltage_Phase_2_val = '" & AO_Voltage_Phase_2_val & "',AO_Amps_Phase_3 = " & AO_Amps_Phase_3 & ",AO_Amps_Phase_3_val = '" & AO_Amps_Phase_3_val & "',AO_Voltage_Phase_4 = " & AO_Voltage_Phase_4 & ",AO_Voltage_Phase_4_val = '" & AO_Voltage_Phase_4_val & "',AO_Amps_Phase_4 = " & AO_Amps_Phase_4 & ",AO_Amps_Phase_4_val = '" & AO_Amps_Phase_4_val & "',AO_Frequency_Under_Load = " & AO_Frequency_Under_Load & ",AO_Frequency_Under_Load_val = '" & AO_Frequency_Under_Load_val & "',AO_Oil_Pressure = " & AO_Oil_Pressure & ",AO_Oil_Pressure_val = '" & AO_Oil_Pressure_val & "',AO_Engine_Temp = " & AO_Engine_Temp & ",AO_Engine_Temp_val = '" & AO_Engine_Temp_val & "',AO_Check_For_Noise = " & AO_Check_For_Noise & ",AO_Check_For_Noise_val = '" & AO_Check_For_Noise_val & "',AO_Time_Delay_To_retransfer = " & AO_Time_Delay_To_retransfer & ",AO_Time_Delay_To_retran_val = '" & AO_Time_Delay_To_retran_val & "',AO_Cool_Down_Time_Delay = " & AO_Cool_Down_Time_Delay & ",AO_Cool_Down_Time_Delay_val = '" & AO_Cool_Down_Time_Delay_val & "',AT_Make = '" & AT_Make & "',AT_Model_Number = '" & AT_Model_Number & "',AT_Serial_Number = '" & AT_Serial_Number & "',AT_Two_Pole = " & AT_Two_Pole & ",AT_Three_Pole = " & AT_Three_Pole & ",AT_Four_Pole = " & AT_Four_Pole & ",AT_Open = " & AT_Open & ",AT_NEMA = " & AT_NEMA & ",AT_NEMA_3R = " & AT_NEMA_3R & ",AT_Other = " & AT_Other & ",AT_Other_val = '" & AT_Other_val & "',BC_Make = '" & BC_Make & "',BC_Model = '" & BC_Model & "',BC_Amp_Rating = '" & BC_Amp_Rating & "',Running_Time_Meter_Reading = " & Running_Time_Meter_Reading & ",Running_Time_Meter_val = '" & Running_Time_Meter_val & "',Suggestions = '" & Suggestions & "',Completed_By = '" & Completed_By & "',Completed_Date = '" & FormatDT(Completed_Date) & "' where startup_id = " & startup_id 'd sql conn.execute(sql) end if if startup_id = "" then startup_id = 0 sql = "select * from startup where startup_id = " & startup_id set rs = conn.Execute(sql) on error resume next if rs.eof then subCap = "Submit" else subCap = "Update" end if %>