I used to have this problem, but I solved it by using 'IS NOT NULL' in my
queries v. using
if rs(fld.value) <> ""
Here's something else from the MySQL manual... Don't know if this will
help
or not...
***
ASP users: if you're getting empty recordset
returned when using COALESCE, add "OPTION=16384"
to your connectionstring, or check "Change Bigint
to Int" in the DSN manager!
***
You could also try SELECT (IF ELSE) statements to force MySQL to output a
'0' instead of a NULL value.
Other than that, this would seem to be an ODBC or ASP issue, not a MySQL
issue, as MySQL is reporting 215 rows correctly and ASP is not.
I would be happy to help off-list if you need another set of eyes on the
coding.
J.R.
-----Original Message-----
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 9:49 AM
To: MySQL List
Subject: Re: ASP Reporting EOF?
I have found a bug report, #11541 which appears to be reporting the same
thing that I am reporting. However, it doesn't indicate that it has been
fixed. If it has not been, this is a serious flaw, and I will not be able
to convert this particular application over to MySQL as it's critical that
it work properly. Does anyone have any information on this?
Thanks,
Jesse
----- Original Message -----
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List" <mysql@lists.mysql.com>
Sent: Monday, June 26, 2006 4:58 PM
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
