大家帮忙看一下这个select语句是什么错误？

[zds835]

这个select语句，有语法错误。各位帮忙改一下：
int zds=+5;
HttpCookie cookie = Request.Cookies["aspqx"]
OdbcCommand cmd=new OdbcCommand("select zhdh,name from dk3 where dqrq between ? and ? and bm=(select distinct bm from qzjdb:login where qx= ?) ",this.conn);
cmd.Parameters.Add("@qx",OdbcType.VarChar, 10);
cmd.Parameters["@qx"].Value=cookie.Value;
cmd.Parameters.Add("@datefrom",OdbcType.VarChar, 10);
cmd.Parameters["@datefrom"].Value=DateTime.Now.ToShortDateString();
cmd.Parameters.Add("@dateto",OdbcType.VarChar, 10);
cmd.Parameters["@dateto"].Value=DateTime.Now.AddDays(+zds).ToShortDateString();

[qinjin2000]

关注中
眼睛都看花了

[真相重于对错]

between ?//what is this
and ?//what is this
and bm=(select distinct bm from qzjdb:login where qx= ?//what is this
) ",this.conn);

[egonzou]

OdbcCommand cmd=new OdbcCommand("select zhdh,name from dk3 where (dqrq between ? and ? )and bm=(select distinct bm from qzjdb:login where qx= ?) ",this.conn);

这样试试看行不行

[sfanpu]

错误提示呢？

[zhy16]

up

[zhy16]

select zhdh,name from dk3 where dqrq between （? and ?） and bm=(select distinct bm from qzjdb:login where qx= ?)
试一下看成不成？

[zds835]

自己解决了。谢谢大家！！！！

[builderman]

bm=(select distinct bm from qzjdb:login where

RE: bm in(select distinct bm from qzjdb:login where