Yes, some of the fields have null values, but not the main key values. I've
also got another report I run in ASP which has null values in it as well,
but it doesn't report EOF. But how could a null value in one of the fields
make it appear EOF?
Thanks,
Jesse
----- Original Message -----
From: "J.R. Bullington" <[EMAIL PROTECTED]>
To: "'MySQL List'" <mysql@lists.mysql.com>
Sent: Monday, June 26, 2006 5:38 PM
Subject: RE: ASP Reporting EOF?
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
