When you run the query in the Query Browser, do any of the records return a 'NULL' value?
If so, then MS's ASP engine would return an EOF because MySQL's NULL is NOT the same as objRS(fld.name) = "". J.R. -----Original Message----- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 4:58 PM To: MySQL List Subject: ASP Reporting EOF? When I run the following query in my ASP Application: SELECT S.State, S.Sub, S.Region, S.District, Sum(Males) AS TotMales, Sum(Females) AS TotFemales, Sum(AfricanAmerican) AS TotAfricanAmericans, Sum(Asian) AS TotAsians, Sum(Caucasian) AS TotCaucasians, Sum(Hispanic) AS TotHispanics, Sum(NativeAmerican) AS TotNativeAmericans, Sum(Other) AS TotOthers, Sum(Grade6) AS TotGrade6s, Sum(Grade7) AS TotGrade7s, Sum(Grade8) AS TotGrade8s, Sum(Grade9) AS TotGrade9s, Sum(Grade10) AS TotGrade10s, Sum(Grade11) AS TotGrade11s, Sum(Grade12) AS TotGrade12s, Sum(AgeBelow22) AS TotAgeBelow22s, Sum(Age22_25) AS TotAge22_25s, Sum(Age26_30) AS TotAge26_30s, Sum(Age31_40) AS TotAge31_40, Sum(AgeOver40) AS TotAgeOver40s, Sum(Disabilities) AS TotDisabilitiess, Sum(EducationallyDisabled) AS TotEducationallyDisableds, Sum(EconomicallyDisadvantaged) AS TotEconomicallyDisadvantageds, Sum(LimitedEnglishProficiency) AS TotLimitedEnglishProficiencys, Sum(NonTraditional) AS TotNonTraditionals FROM Chapters C, Schools S WHERE C.SchoolID=S.ID GROUP BY S.State, S.Sub, S.Region, S.District ORDER BY S.State, S.Sub, S.Region, S.District The dataset returns EOF, however, it's NOT EOF. I can execute this query in MySQL Query Browser, and it returns 215 rows. I've recently converted this table from InnoDB to MyISAM, which seems to be faster, but I can't figure out why it would say it was at EOF when it's not! I've got other queries that don't return EOF, why would this one? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
