Re: ASP Reporting EOF?

2006-06-27 Thread Jesse
- 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

Re: ASP Reporting EOF?

2006-06-27 Thread Jesse
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

RE: ASP Reporting EOF?

2006-06-27 Thread J.R. Bullington
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

Re: ASP Reporting EOF?

2006-06-27 Thread Jesse
Found the problem. I upgraded to version 3.51.12 of the ODBC driver, and the problem was solved. 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

Re: ASP Reporting EOF?

2006-06-27 Thread Jesse
List' mysql@lists.mysql.com Sent: Tuesday, June 27, 2006 10:08 AM Subject: RE: ASP Reporting EOF? 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

ASP Reporting EOF?

2006-06-26 Thread Jesse
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,

RE: ASP Reporting EOF?

2006-06-26 Thread J.R. Bullington
, 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