源文件中的代码：rs.open "select shop_books.bookid,shop_books.bookname,shop_books.shichangjia,shop_books.huiyuanjia,shop_action.actiondate,shop_action.shousex,shop_action.danjia,shop_action.feiyong,shop_action.fapiao,shop_action.userzhenshiname,shop_action.shouhuoname,shop_action.dingdan,shop_action.youbian,shop_action.liuyan,shop_action.zhifufangshi,shop_action.songhuofangshi,shop_action.zhuangtai,shop_action.zonger,shop_action.useremail,shop_action.usertel,shop_action.shouhuodizhi,shop_action.bookcount from shop_books inner join shop_action on shop_books.bookid=shop_action.bookid where shop_action.shjiaid="&id&" and dingdan='"&dingdan&"' ",conn,1,1
if rs.eof and rs.bof then

打开网页时提示：
错误类型：
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'shop_action.shjiaid= and dingdan=''' 中。

请问高手，该怎么修改，谢谢，谢谢！

[此贴子已经被作者于2006-3-25 22:16:57编辑过]

dingdan
id
就没有验证是否为空吗？

ID这个值是空的!