Sqlite 语法出错解决方法

Sqlite 语法出错

SQL code

SELECT acSiteGroup_AcquisitionInfo.fldGuid, acSiteGroup_AcquisitionInfo.fldName,       acSiteGroup_AcquisitionContent.fldContentFROM acSiteGroup_AcquisitionInfo INNER JOIN      acSiteGroup_AcquisitionContent ON       acSiteGroup_AcquisitionContent.fldGuid = acSiteGroup_AcquisitionInfo.fldGuid WHERE (acSiteGroup_AcquisitionInfo.fldGuid NOT IN          (SELECT fldInfoGuid         FROM acSiteGroup_AcquisitionContentPost         WHERE (fldPostGuid = @fldPostGuid))) limit 1, 10

我想查 acSiteGroup_AcquisitionInfo.fldGuid 不在 acSiteGroup_AcquisitionContentPost 表中的数据
当取消 limit 1, 10 条件时，能正确查处所有数据
但是加上运行之后就报错 错误：
Insufficient parameters supplied to the command

[解决办法]

查看更多 下一篇