asp语句帮忙

来源:百度知道 编辑:UC知道 时间:2024/06/27 08:42:00
function GetOrders1()
vsql = "SELECT o.cn_orderno AS orderno, o.cn_gross AS gross, o.cn_statustwo AS statustwoid, o.cn_statusthr AS statusthrid,o.cn_status AS statusid, g.cn_name AS gname,s.cn_name AS sname,d.cn_character AS dcharacter,d.cn_item_no AS ditem, o.cn_payment_date AS pdate FROM orders AS o, users AS u,orderdetails AS d,games AS g,server AS s WHERE d.cn_orderno=o.cn_orderno and d.cn_gameid=g.cn_id and d.cn_serverid=s.cn_id and u.cn_id=o.cn_userid and o.cn_status='未处理' order by cn_payment_date desc"'"select * from orders order by cn_payment_date desc"
set vrs = GetRsBySQLStr(vsql)
set GetOrders1 = vrs
end function

o.cn_status='未处理'是有这个条目,但就是读不到数据,如果数据库里o.cn_status字段里数据改成英文,就能读出来,是不是这条不能这样写啊
function GetOrders1()
dim stu as string
stu = "未处理"
vsql = "SELECT o.cn_orderno AS orderno, o.cn_gross AS gross, o.cn_statustwo AS statustwoid, o.cn_statusthr AS statusthri

是的,应该是引号用法错误,你把未处理赋值给一个变量wcl.然后你把这段函数换成我给你改的这段试试:
function GetOrders1()
vsql = "SELECT o.cn_orderno AS orderno, o.cn_gross AS gross, o.cn_statustwo AS statustwoid, o.cn_statusthr AS statusthrid,o.cn_status AS statusid, g.cn_name AS gname,s.cn_name AS sname,d.cn_character AS dcharacter,d.cn_item_no AS ditem, o.cn_payment_date AS pdate FROM orders AS o, users AS u,orderdetails AS d,games AS g,server AS s WHERE d.cn_orderno=o.cn_orderno and d.cn_gameid=g.cn_id and d.cn_serverid=s.cn_id and u.cn_id=o.cn_userid and o.cn_status='"&wcl&"' order by cn_payment_date desc"'"select * from orders order by cn_payment_date desc"
set vrs = GetRsBySQLStr(vsql)
set GetOrders1 = vrs
end function
你这里怎么会有两段查询语句啊?你先试试,不行再说,问题肯定是在引号用法错误!