总是说我类型不匹配,这是为啥呢?
以下这句总是提示数据类型不匹配:
<%sql = "select * from xf where phone1 ="&session("phone1")&" order by "&order&" desc"%>
把这句改成
<%sql = "select * from xf order by "&order&" desc"%> 就没有问题了
我用response.write 把第一句写出来以后,显示为:
select * from xf where phone1 =15611074321 order by id desc
这是为什么呢?我改怎么修改呢,请各位帮忙。
------解决方案--------------------<%sql = "select * from xf where phone1 ='"&session("phone1")&"' order by "&order&" desc"%>
''括起,你的phone1类型是字符而不是数字吧..