Question

SELECT 子句中包含一个保留字、拼写错误或丢失的参数，或标点符号不正确

set rsShowRecommendShop = conn.execute("select top "&tuijian_shop&" * from shop where tuijian_shop='1' order by id desc " )

上面那句提示我
Microsoft JET Database Engine (0x80040E14)
SELECT 子句中包含一个保留字、拼写错误或丢失的参数，或标点符号不正确。
/shop/FFunction.asp, 第 427 行

请大家帮帮忙吧！

Answer 1

tuijian_shop
可能没有过来值

Answer 2

select top "&tuijian_shop&" * from shop where tuijian_shop='1' order by id desc "

改成 select top 3 from shop where tuijian_shop='1' order by id desc "

Answer 3

id是保留字
改成
select top "&tuijian_shop&" * from shop where tuijian_shop='1' order by [id] desc