asp wap出错,模拟器一切正常,手机访问出错
用winwap访问正常
用摩托罗拉手机访问,第一页正常,输入查询条件后,第二页出现500错误,源码如下:
第一页:
<%@ Language=VBScript %>
<% Response.ContentType="text/vnd.wap.wml" %>
<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/ wml_1.1.xml">
<wml>
<card id="qycx" title="博云东方在线库存手机版">
<p>
牌号:<input name="qycx" type="text" maxlength="16" />
型号:<input name="model" type="text" maxlength="16" />
<anchor title="确定">确定
<go href="qycx.asp" method="post">
<postfield name="qycx" value="$qycx"/>
<postfield name="model" value="$model"/>
</go>
</anchor>
<br/><br/>
博云
</p>
</card>
</wml>
第二页:
<%@ Language=VBScript %>
<% Response.ContentType = "text/vnd.wap.wml" %>
<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/ wml_1.1.xml">
<wml>
<card id="qycx2" title="博云东方在线库存">
<p>
<%
dim SQLServerName
dim SQLDBUserName
dim SQLDBPassword
dim SQLDBName
dim connstr
SQLServerName="192.168.0.1" '数据库服务器名或者IP,本机填“(local)”
SQLDBUserName="sa" '数据库帐号
SQLDBPassword="" '数据库密码
SQLDBName="rossdb" '数据库名称
qycx=request.FORM("qycx")
model = request.FORM("model")
cx=" MMF.Name like '%" & qycx & "%' and Stock.Model1 LIKE '%" & model & "%' order by stock.model1"
Set conn=Server.CreateObject("ADODB.connection")
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=" & SQLServerName & ";User ID=" & SQLDBUserName & ";Password=" & SQLDBPassword & ";Database=" & SQLDBName & ";"
conn.Open connstr
sql="Select MMF.Name,Stock.Model1 as Model ,Stock.Qty,Stock.Weight,Stock.Indate as BeginDate,Series.Name as SeriesNM FROM Stock,MMF,Locate,Series WHERE MMF.MatID=Stock.MatID AND Stock.LocateID=Locate.LocateID AND MMF.SeriesID=Series.SeriesID AND Stock.Qty<>0 and stock.locateID='101'AND " & cx &""
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof
%>
<%qymc=rs("name")%>
牌号:<%Response.write qymc%>
<%
id=rs("model")%>
型号:<%Response.write id%>
<%
qty=rs("qty")%>
重量:<%Response.write qty%>
<%
id=rs("Weight")%>
数量:<%Response.write Weight%>
</p>
<br/>
<%
rs.movenext
loop
rs.close
%>
<br/><br/>
博云东方
</p>
</card>
</wml>
<% Function uni(Chinese)
For i = 1 to Len (Chinese)
a=Mid(Chinese, i, 1)
uni=uni & "&#x" & Hex(Ascw(a)) & ";"
next
End Function
%>