UC知道求改sql搜索语句
来源：百度知道 编辑：UC知道 时间：2024/09/24 06:59:33
id=request.Form("key")
sql="select * from wu_tuijian,wu_xinxikuaidi,wu_xinpian,wu_biaoge,wu_dangjian,wu_shishi,wu_dangxue,wu_honglv,wu_shiqida where news_title like '"&id&"' order by new_id desc"
sql="select * from wu_tuijian,wu_xinxikuaidi,wu_xinpian,wu_biaoge,wu_dangjian,wu_shishi,wu_dangxue,wu_honglv,wu_shiqida where news_title like '"&id&"' order by new_id desc"
sql="select wu_tuijian,wu_xinxikuaidi,wu_xinpian,wu_biaoge,wu_dangjian,wu_shishi,wu_dangxue,wu_honglv,wu_shiqida from wu where news_title like '%"&id&"%' order by new_id desc"
你选的表那么多？并且没关联？
wu_tuijian,wu_xinxikuaidi,wu_xinpian,wu_biaoge,wu_dangjian,wu_shishi,wu_dangxue,wu_honglv,wu_shiqida
这些是表还是字段啊，你先弄清楚
sql="select * from wu_tuijian,wu_xinxikuaidi,wu_xinpian,wu_biaoge,wu_dangjian,wu_shishi,wu_dangxue,wu_honglv,wu_shiqida where convert(char(100),news_title like'%"&id&"%' order by new_id desc"
补充: 好像Access中通配符是"*"
sql="select wu_tuijian,wu_xinxikuaidi,wu_xinpian,wu_biaoge,wu_dangjian,wu_shishi,wu_dangxue,wu_honglv,wu_shiqida from wu where news_title like '*" & id & "*' order by new_id desc"