＋设为首页 ＋添加到收藏夹
sql="select * from house where mytype = "&mytype&" and fw_quyu = "&fw_quyu&" and fw_jiegou= "&fw_jiegou&" and fw_danwei= "&fw_danwei&" and datediff(d,fw_fbri,date()) <= "& fw_guoqi &""
sql="select * from house where mytype = "&mytype&" and fw_quyu = "&fw_quyu&" and fw_jiegou= "&fw_jiegou&" and fw_danwei= "&fw_danwei&" and datediff(d,fw_fbri,date()) <= "& fw_guoqi &""
是什么出错提示
response.write sql
response.end
看看打印出来的sql是什么样的！
楼主应该看看datediff的用法,第一个参数不能有单引号的,去sql联机丛书看看吧!受益匪浅噢
