Question

asp多条件查询的sql语句

请问ASP多条件搜索的语句怎么写呀 比如在t_main表中的id字段与u_user表中的id对应现在要找在t_main中show=true 并且id在u_user表中show=true的值后面就是用户输入的关键字 和其它字段的值 用倒序排列

Answer 1

循环： set rs1 set rs2 sql1 = "select * from t_main where show = true order by id desc" do while not rs1.eof rs1("id") sql2 = "select * from u_user where id = " & rs1("id") & " and show = true order by id desc" rs2("id") rs1.movenext loop