Function NA(s)
if s<>"" then
NA = s
Else
NA = "Not Available"
End if
End Function
PartNo =UCase(Request("PartNo"))
if PartNo="" then
Response.ContentType = "text/vnd.wap.wml"
Response.AddHeader "Location", "http://" & SERVERURL & "/" & Session("HomePage")
Response.End
End if
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''RECORDSET OBJECT SET FOR THE FINAL QUERY TO THE TABLE
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
OpenCon
Set RS = Server.CreateObject("ADODB.Recordset")
'Sql = "SELECT stklist.stkcode,stkname,Count(Qty) as qty from stkList inner join stkcntrl on "
'SQL = SQL & " stklist.stkcode=stkcntrl.stkcode "
'Sql = sql & " where partno ='"& PartNo &"' And stkstat='Stock' group by stkname,stklist.stkcode;"
Sql = "SELECT distinct stkCode from stkList Where PartNo ='"& PartNo & "'"
'And stkstat='Stock' group by stkcode;"
Response.ContentType = "text/vnd.wap.wml"
With (Response)
.write("<?xml version=""1.0""?><!DOCTYPE wml PUBLIC ""-//WAPFORUM//DTD WML 1.1//EN"" ""http://www.wapforum.org/DTD/wml_1.1.xml"">")
.write(vbCrLf)
.write("<wml><card title=""Xls Express"" id=""Main""><do type=""accept"" label=""New Search""><go href=""PL.asp""/></do><do type=""accept"" label=""Home""><go href=""" & Session("HomePage") & """/></do>")
.write("<p><b>Part No: " & PartNo & "</b><br/>")
On Error Resume Next
RS.Open SQL,con,3
recCount = rs.RecordCount
IF not RS.EOF then
set rs2=server.CreateObject("adodb.recordset")
While not rs.EOF
stkCode=Trim(RS("stkCode"))
SQL="SELECT Count(PartNo) as CNT1 FROM stkList where PartNo='" & PartNo & "' and stkStat='Stock' and stkCode='" & stkCode & "'"
if rs2.state=1 then rs2.Close
rs2.Open sql,con,3
if not rs2.EOF then
stkQty=rs2.Fields(0)
else
stkQty=0
end if
SQL=" SELECT Count(PartNo) as CNT2 FROM stkList where PartNo='" & PartNo & "' and stkStat!='Stock' and stkCode='" & stkCode & "'"
'response.Write(sql)
if rs2.State=1 then rs2.Close
rs2.Open sql,con,3
if not rs2.EOF then
tranQty=rs2.Fields(0)
else
tranQty=0
end if
.write("<a href=""PLBin.asp?PartNo=" & PartNo & "&s=" & stkCode & """>" & NA ( stkCode ) & " " & stkQty & " ( " & tranQty & " )</a><br/>")
rs.MoveNext
wend
Else
.write("<b>Not Found!</b><br/>")
End if
.write("<br/><a href=""CPMResult.asp?cPartNo="& PartNo & """>Compatible</a>")
.write("<br/><a href=""PL.asp"">New Search</a><br/><a href=""" & Session("HomePage") & """>Home</a>")
.write("</p></card></wml>")
End With
%>