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]
