<%@ LANGUAGE="VBScript" %>
<%
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Mode = adModeRead
Connection.Open phdb_rd
SQLStmt= "SELECT bonding_pattern,pad,sensor_column,sensor_row,bi.sensor_type st,mask_revision mr FROM sitester.type_con tc,sitester.batch_info bi"
SQLStmt= SQLStmt & " WHERE tc.sensor_type=bi.sensor_type"
SQLStmt= SQLStmt & " AND bi.batch='" & Request("batch_x") & "'"
SQLStmt= SQLStmt & " AND tc.bonding_pattern=" & Request("bonding_pattern_x")
SQLStmt= SQLStmt & " AND tc.pad=" & Request("pad_x")
Set RS = Connection.Execute(SQLStmt)
%>
Bonding_pattern/Pad to Column/Row conversion
<% Do While Not RS.EOF %>
Bonding Pattern <%=RS("Bonding_Pattern")%> and Pad <%=RS("Pad")%> in <%=Sensor_Name(RS("st"),RS("mr"))%> correspond to Column <%=RS("sensor_column")%> and Row <%=RS("sensor_row")%>