Batch <%= Request("batch") %>, Sensor <%= Request("sensor") %> Broken Channel Report

<%@ LANGUAGE="VBScript" %> <% start_time = Time Server.ScriptTimeOut=600 Set Connection = Server.CreateObject("ADODB.Connection") Connection.Mode = adModeRead Connection.Open phdb_rd Datasubquery1="(select MAX(logdate) from sitester.sensor_log where batch='"+Request("batch")+"' and sensor="+CStr(Request("sensor"))+" and action='Summary' and measurement_type='Sensor_data')" DataQuery = "select * from sitester.sensor_log,sitester.channel_properties where batch='"+Request("batch")+"' and sensor="+CStr(Request("sensor"))+" and logdate=entrydate and logdate="+Datasubquery1+" order by bonding_pattern,pad" Set Data = Connection.Execute(DataQuery) %> Batch <%= Request("batch") %>, Sensor <%= Request("sensor") %> Broken Channel Report

Batch <%= Request("batch") %>, Sensor <%= Request("sensor") %> Broken Channel Report

<% Do While Not Data.EOF %> <% Data.MoveNext Loop %>

Bonding Pattern	Pad	Why Broken?
<%= Data("bonding_pattern") %>	<%= Data("pad") %>	<%= Data("measurement_id") %>

<% Connection.Close %>