当前位置: 代码迷 >> 其他数据库 >> Sqlite 语法出错解决方法
  详细解决方案

Sqlite 语法出错解决方法

热度:10022   发布时间:2013-02-26 00:00:00.0
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

------解决方案--------------------------------------------------------
  相关解决方案