多种用户登录方式问题

[hualoveqi]

要实现用户可以选择多种类型登录，我写的sql语句如下：
SELECT * FROM users
WHERE (abNumber = @ab) AND (Pwd = @pwd) OR
(cdNumber = @cd) AND (Pwd = @pwd) OR
(DataExNumber = @data) AND (Pwd = @pwd) OR
(ddNumber = @dd) AND (Pwd = @pwd) OR
(CallCenterNumber = @call) AND (Pwd = @pwd) OR
(MsgNumber = @msg) AND (Pwd = @pwd) OR
(XunHuNumber = @xunhu) AND (Pwd = @pwd) OR
(CunChuNumber = @cun) AND (Pwd = @pwd) OR
(VirtualNumber = @vir) AND (Pwd = @pwd) OR
(VsatNumber = @vsat) AND (Pwd = @pwd)

在本地测试可以根据输入的参数查询出数据，但是上传到服务器后输入相应参数它查询出来的数据总是某一条，为什么啊？郁闷中！！~

[hualoveqi]

SELECT * FROM users
                              WHERE (abNumber = @ab) AND (Pwd = @pwd) OR
                             (cdNumber = @cd) AND (Pwd = @pwd) OR
                             (DataExNumber = @data) AND (Pwd = @pwd) OR
                             (ddNumber = @dd) AND (Pwd = @pwd) OR
                             (CallCenterNumber = @call) AND (Pwd = @pwd) OR
                             (MsgNumber = @msg) AND (Pwd = @pwd) OR
                             (XunHuNumber = @xunhu) AND (Pwd = @pwd) OR
                             (CunChuNumber = @cun) AND (Pwd = @pwd) OR
                             (VirtualNumber = @vir) AND (Pwd = @pwd) OR
                             (VsatNumber = @vsat) AND (Pwd = @pwd)

[liuyjcel]

WHERE (abNumber = @ab) AND (Pwd = @pwd) OR

and 和 or之间，你是不是没有理清楚啊。。