中科新闻网仙剑奇侠传6 破解补丁:这样写sql语句正确吗？
来源：百度文库 编辑：中科新闻网 时间：2024/05/14 13:05:00
<%
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"