UC知道请教vb中用spilt拆分数组越界问题
来源：百度知道 编辑：UC知道 时间：2024/07/12 14:51:32
部分代码如下：
dim act
act=request("act")
QueryString = Request.form( "keywords" )
QueryWords = Split( QueryString)
strIndent = " "
sql= "SELECT * FROM find WHERE gname LIKE '%" & QueryWords( 0 ) & "%' or gwork LIKE '%" & QueryWords( 0 ) & "%'"
set rs=server.CreateObject("adodb.recordset")
rs.Open sql,conn,1,3
改成：sql= "SELECT * FROM find WHERE gname LIKE '%" & lbound(QueryWords) & "%' or gwork LIKE '%" & ubound(QueryWords) & "%'
后；它的错误提示是：
接受参数不正确，或者是相关参数起冲突
dim act
act=request("act")
QueryString = Request.form( "keywords" )
QueryWords = Split( QueryString)
strIndent = " "
sql= "SELECT * FROM find WHERE gname LIKE '%" & QueryWords( 0 ) & "%' or gwork LIKE '%" & QueryWords( 0 ) & "%'"
set rs=server.CreateObject("adodb.recordset")
rs.Open sql,conn,1,3
改成：sql= "SELECT * FROM find WHERE gname LIKE '%" & lbound(QueryWords) & "%' or gwork LIKE '%" & ubound(QueryWords) & "%'
后；它的错误提示是：
接受参数不正确，或者是相关参数起冲突
dim a
a = split(a, "分隔符")
a就是数组了
用lbound(a)和ubound(a)取得上下边界值
====
添加:
你QueryWords是什么啊?
sql起码要是一句正确的sql查询语句才行啊