Posted Wednesday, July 21, 2004 @ 09:53:38
I'm still having the same problem even though I use the following query for setSelectSql(...):
SELECT MailData.ID ,MailData.FName ,MailData.LName ,MailData.Company ,MailData.StreetAddress1 ,MailData.StreetAddress2 ,MailData.City ,MailData.State ,MailData.Zip ,MailData.Zip4 ,SourceInfo.Source ,ClassTypes.ClassType
FROM
(((((((MailData INNER JOIN Source ON MailData.ID=Source.ID) INNER JOIN SourceInfo ON Source.SourceID=SourceInfo.SourceID) INNER JOIN Class ON MailData.ID=Class.ID) INNER JOIN ClassTypes ON Class.ClassCode=ClassTypes.ClassCode) LEFT JOIN MailSent ON MailData.ID=MailSent.ID) LEFT JOIN Mailings ON MailSent.MailID=Mailings.MailID) LEFT JOIN MailTypes ON Mailings.MailTypeID=MailTypes.MailTypeID)
WHERE
(ClassTypes.ClassType LIKE 'GE55') GROUP BY MailData.ID
I even use table.setRowCountSql("SELECT COUNT(*) FROM (above query) AS AB").
I use mysql database. When I ran the count sql statement manually I got the count=425,953
Am I doing something wrong?