<%
Set desc = Server.CreateObject("ADODB.Connection")
desc.ConnectionTimeout = Session("DataConn_ConnectionTimeout")
desc.CommandTimeout = Session("DataConn_CommandTimeout")
desc.Open Session("DB_SMART")
SQLQuery = "SELECT DISTINCT MATRIXNAME, MATRIXKEY1, MATRIXKEY2, MATRIXKEY3, MATRIXKEY4, MATRIXKEY5, MATRIXVALUE FROM SMART.dbo.SEARCHMATRIX WHERE MATRIXNAME='STDEQUIP' AND MATRIXKEY1 = 'SCGNQS' AND MATRIXKEY2 = 'UNDERCARRIAGE' ORDER BY MATRIXKEY3"
Set text_sql = desc.Execute(SQLQuery)
'response.write sqlquery
if not text_sql.eof then
response.write "
"
While not text_sql.eof
%>
<%= text_sql("matrixvalue")%>
<%
text_sql.movenext
WEND
end if
text_sql.close
desc.close
set desc = nothing
%>