一个asp数据库select * from的问题谢谢了,大神帮忙啊
哪里有错误呢?我怎么也找不到,求帮助shijian=now()rs.open"select*from会员用户信息where会员到期时间<'"&shijian&"'and会...
哪里有错误呢?我怎么也找不到,求帮助 shijian=now() rs.open "select * from 会员用户信息 where 会员到期时间<'" & shijian & "' and 会员到期时间='" & shijian & "'",con,1,3 If rs.RecordCount > 0 Then i = 1 Do While Not rs.eof huiyuanyonghuzhanghao=rs("会员用户帐号") huiyuanyonghumima=rs("会员用户密码") huiyuanzhuceshijian=rs("会员注册时间") huiyuandaoqishijian=rs("会员到期时间") huiyuanyouxizhanghaobangding=rs("会员游戏帐号绑定") yichongzhikadezhanghao=rs("已充值卡的帐号") yonghushifoubeitongfeng=rs("用户是否被停封") liuyan=rs("留言") cishu=rs("试用次数") zuihouyici=rs("最后一次启动时间") rs.MoveNext i = i + 1 response.write huiyuanyonghuzhanghao & "|々|" & huiyuanyonghumima & "|々|" & huiyuanzhuceshijian & "|々|" & huiyuandaoqishijian & "|々|" & huiyuanyouxizhanghaobangding & "|々|" & yichongzhikadezhanghao & "|々|" & yonghushifoubeitongfeng & "|々|"& liuyan & "|々|"& cishu & "|々|"& zuihouyici & "|々|" Loop End If rs.Close
展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询