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]
