6 Replies Latest reply on Dec 4, 2003 9:32 AM by gavinandrews

    very long SQL-Statement

    Thomas Newbie

      I log on level=DEBUG an see the following statement:
      [Constant] Executing SQL: SELECT CST_ID,CST_GRPID, CST_TEXT FROM TBL_CONSTANT WHERE (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR OR (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR (CST_ID=?) OR
      D=?) OR (CST_ID=?) ... OR (CST_ID=?)
      The application works correct but I think this statement is a very long version findAll(). The counts of (CST_ID=?) is equal the row of this DB-table. What`s wrong?