在线等,急..查询的代码出错...我是初学者....请各位高手帮忙

asdfghjkl4844 2012-10-09 09:36:51

string search = "";

if (Request.QueryString["ppxx"] != null)
{
search += " order31 like '%" + Request.QueryString["ppxx"] + "%' ";
}

sqlshow = "select * from orderline where order33='接单' " + search + " order by id desc";这一句错在哪里................

...全文

153 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

摇滚雪碧 2012-10-09

打赏
举报

恩 order33='接单' 加个 and 就哦了

worldhj1 2012-10-09

打赏
举报

果然是初学者。。。。。and.....

family300 2012-10-09

打赏
举报

两个查询条件之间缺少一个and，你可以用search += " And order31 like '%" + Request.QueryString["ppxx"] + "%' ";或则sqlshow = "select * from orderline where order33='接单' and " + search + " order by id desc";两种方式解决

在路上20130607 2012-10-09

打赏
举报

sqlshow = "select * from orderline where order33='接单' " + search + " order by id desc";

sqlshow = "select * from orderline where order33='接单' and " + search + " order by id desc";

孟子E章 2012-10-09

打赏
举报

and

SocketUpEx 2012-10-09

打赏
举报

search += " And order31 like '%" + Request.QueryString["ppxx"] + "%' ";

a4562834 2012-10-09

打赏
举报

search += " and order31 like '%" + Request.QueryString["ppxx"] + "%' ";

lyh2ysy 2012-10-09

打赏
举报

[Quote=引用楼主的回复:]
string search = "";

if (Request.QueryString["ppxx"] != null)
{
search += " order31 like '%" + Request.QueryString["ppxx"] + "%' ";
}

sqlshow = "select * from orderline where order33……
[/Quote]
注意红色字体部分
sqlshow = "select * from orderline where order33='接单' And" + search + " order by id desc";

service490229980 2012-10-09