高考问答包王vs夜枫三问:这样写sql语句正确吗？
来源：百度文库 编辑：高考问答 时间：2024/05/06 04:42:07
<%
lwcx=trim(request("lwcx"))
set rs=server.createobject("adodb.recordset")
sql="SELECT * FROM lunwen,jg WHERE lunwen.id=jg.id and luwen.lwyear='"&lwcx&"' and jg.isdeletetozhan = '否' and jg.ischeck like 0"
rs.open sql,conn,1,2
%>
lwcx=trim(request("lwcx"))
set rs=server.createobject("adodb.recordset")
sql="SELECT * FROM lunwen,jg WHERE lunwen.id=jg.id and luwen.lwyear='"&lwcx&"' and jg.isdeletetozhan = '否' and jg.ischeck like 0"
rs.open sql,conn,1,2
%>
lwcx=trim(request("lwcx")) ‘这里应该判断一下request是否能得到值，否则报错
set rs=server.createobject("adodb.recordset")
sql="SELECT * FROM lunwen,jg WHERE lunwen.id=jg.id and luwen.lwyear='"&lwcx&"' and jg.isdeletetozhan = '否' and jg.ischeck like 0" ‘这里的ischeck是什么字段？你的本意是什么？如果想要like匹配的时候应该是like '%0%'
sql="SELECT * FROM lunwen,jg WHERE lunwen.id=jg.id and luwen.lwyear='"&lwcx&"' and jg.isdeletetozhan = '否' and jg.ischeck=0"