Re: ASP Reporting EOF?

2006-06-27 Thread Jesse
OTECTED]> To: "'MySQL List'" 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 th

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" Sent: Monday, June 26, 2006 4:58 PM Subject: ASP Reporting EOF? When I run the following query in my ASP A

RE: ASP Reporting EOF?

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

Re: ASP Reporting EOF?

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

Re: ASP Reporting EOF?

2006-06-27 Thread Jesse
al Message - From: "J.R. Bullington" <[EMAIL PROTECTED]> To: "'MySQL List'" 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&

RE: ASP Reporting EOF?

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