Question

asp sql语句执行问题

第二个的sql语句加条件后和没加条件一样 ，放在sql中可以执行，没有问题
Set rs = Server.CreateObject("ADODB.RecordSet")
If Request("danhao")<>"" Then
Sql = "Select * From [list] Where danhao='"&Request("danhao")&"'"
else
Sql = "Select * From [list] where jindu like '%客户已取机%'"
End If

Answer 1

1.先换等号，看看你的SQL数据是不是都包含“客户已取机”
Sql = "Select * From [list] where jindu = '客户已取机'"

2。没有搞定你的意思，你第二个SQL的意思是不是要查询 danhao = ‘’ 并且jindu '%客户已取机%'的，那你把这个条件加上啊
Sql = "Select * From [list] where jindu like '%客户已取机%'" and danhao = ‘’