服务器端用VBscript,客户端请求老是说什么语句未结束........
这是我的一个服务器端程序:getPrices.asp:
==========================
<%
Dim conn,rs1
Dim connStr
Dim sqlStr1,sqlStr2,sqlStr3,gameID,serverID
'创建数据库连接对象并打开
Set conn=server.createobject("adodb.connection")
Set rs = server.CreateObject("ADODB.Recordset")
connStr="Provider=Microsoft.jet.oledb.4.0;data Source="& server.mappath("data.mdb")
conn.open(connStr)
gameID=Request.QueryString("gameID")
serverID= Request.QueryString("serverID")
sqlStr1="select priceSource,priceContent,updateTime,orderURL from Servers where Servers.gameID='"& gameID &"'"
sqlStr2=sqlStr1&" and Servers.serverID='"& serverID &"'"
sqlStr3="select coinType from Games where Games.gameID='"& gameID &"'"
rs.Open sqlStr3,conn
Response.Write " <table> <tr>"
Response.Write " <td>WEBsite </td>"
Dim coinTypeStr
while not rs.eof
coinTypeStr=rs("coinType")
rs.movenext
wend
Dim arrayCoinType=Split(coinTypeStr,",",-1,1)
for i=0 to ubound(arrayCoinType)-2
Response.Write " <td>"& arrayCoinType(i) &" </td>"
next
rs.close
Response.Write " <td>Update </td> <td>Order </td> </tr>"
rs.Open sqlStr2,conn
while not rs2.eof
Response.Write " <tr>"
Response.Write " <td>"& rs("priceSource") & " </td>"
Dim priceStr=rs("priceContent")
Dim myArray=Split(priceStr, ",", -1, 1)
for i=0 to ubound(myArray)-2
Response.Write(" <td>"& myArray(i) &" </td>")
next
Response.Write " <td>" & rs("updateTime") &" </td>"
Response.Write " <td> <img src='order.gif'> <a href='"& rs("orderURL") &" </a> </img> </td>"
Response.Write " </tr>"
rs.movenext
wend
Response.Write " </table>"
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
============================
可客户端请求时,却出现这样的错误:
错误类型:
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/coinPrice/getPrice.asp, line 23, column 17
Dim arrayCoinType=Split(coinTypeStr,",",-1,1)
----------------^
是不是Split的用法不对呢??
coinTypeStr=rs("coinType") 这句中:表记录中coinType字段(文本型的)的值是这样的,比如A1,A2,A3,A4
然后我就想用split方法拆分成一个数组,但老是说什么语句未结束...........请问我哪里不对啊?