关键字and附近的语法不正确 [英] Incorrect syntax near the keyword and

问题描述

rs.Open "SELECT forum_msg.*,members.mod_forum,members.mod_all,members.name,members.occupation,members.points_total,members.avatar_url,members.online_status,category.cat_name,category.cat_id FROM (forum_msg INNER JOIN members ON forum_msg.member_id=members.member_id) INNER JOIN category ON forum_msg.cat_id=category.cat_id where group_id="&group_id&" and not status>1 order by msg_id asc",con,1,3

它在关键字and
附近显示错误，例如语法不正确
请帮助我
在此先感谢

it shown an error like Incorrect syntax near the keyword and

please help me
Thanks in advance

推荐答案

rs.Open "SELECT forum_msg.*,members.mod_forum,members.mod_all,members.name,members.occupation,members.points_total,members.avatar_url,members.online_status,category.cat_name,category.cat_id FROM (forum_msg INNER JOIN members ON forum_msg.member_id=members.member_id) INNER JOIN category ON forum_msg.cat_id=category.cat_id where group_id="&group_id&" and not status>1 order by msg_id asc",con,1,3

看一下WHERE条件.
其中，group_id =& group_id&" 而非状态> 1 (按msg_id asc排序)

更改该行，如下所示

Look at the WHERE condition.
where group_id="&group_id&" and not status>1 order by msg_id asc

Change that line like as below

where group_id="&group_id&" and status<>1 order by msg_id asc
where group_id="&group_id&" and status<1 order by msg_id asc

这篇关于关键字and附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！