strQuery = "select zhuany,xuelcc,name,sex,city,ruxtzsbh,dianh1,address from xuej " strQuery=strQuery & " where qih= '" & qih & "' " strQuery=strQuery & " order by ruxtzsbh "
ASP中无变量后缀&,VB则有,所以就会出错,写时要注意规范空格。
strQuery = "select zhuany,xuelcc,name,sex,city,ruxtzsbh,dianh1,address from xuej " strQuery=strQuery & " where qih='" & qih & "' order by ruxtzsbh" 试试看吧,注意顺序问题及空格问题!
这句要这么写strQuery=strQuery & " where qih='" & qih & "'"
strQuery = "select zhuany,xuelcc,name,sex,city,ruxtzsbh,dianh1,address from xuej"strQuery=strQuery & " where qih='" & qih & "'order by ruxtzsbh"
strQuery=strQuery &"where qih='"&qih& "'"
应:
strQuery=strQuery &" where qih='" & qih & "'"
strQuery=strQuery & " where qih= '" & qih & "' "
strQuery=strQuery & " order by ruxtzsbh "
strQuery=strQuery & " where qih='" & qih & "' order by ruxtzsbh"
试试看吧,注意顺序问题及空格问题!