Gerald,
I've written to them asking your question.
I'd like to point out that I just got an empty record set when it is running
under ASP.
The query runs successfully through phpMyAdmin 2.0.5. I realized that the
query
(select count(*) as quantity from person;) works well in ASP so that I think
it should be something
related to GROUP BY clause.
Celso.
----- Original Message -----
From: Gerald L. Clark <[EMAIL PROTECTED]>
To: Celso Pires <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:11
Subject: Re: Upgrading MySQL causes Error - ASP
> They replaced your MySQL with a new version.
> Did they re-compile Apache and PHP to use the new MySQL libraries,
> or is it trying to use the now missing ones?
>
> Celso Pires wrote:
> >
> > Hi there,
> >
> > I've got a site hosted at an ISP and everything was going well when they
> > decided to upgrade the software. Now my site is running under Win2K,
IIS5,
> > MySQL 3.23.33 and MyODBC 2.50.36.
> > In order to get easier to explain what is going wrong, I've built the
> > following test:
> >
> > CREATE TABLE person (
> > person_ID INTEGER NULL,
> > name CHAR(50) NULL,
> > gender CHAR(1) NULL
> > );
> >
> > INSERT INTO person (person_id, name, gender) values
> >
(1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m
');
> >
> > mysql> select count(*) as quantity, gender
> > -> from person
> > -> group by gender;
> > +----------+--------+
> > | quantity | gender |
> > +----------+--------+
> > | 2 | f |
> > | 3 | m |
> > +----------+--------+
> > 2 rows in set (0.01 sec)
> >
> > *** As you can realize, so far so good. Now things get worse ***
> >
> > <html>
> > <head>
> > <title>GROUP BY TEST</title>
> > </head>
> > <body bgcolor="#FFFFFF">
> > <%
> > Response.Write "Begin<br>"
> >
> > strConn =
> >
"DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;"
> > Set conn = Server.Createobject("ADODB.Connection")
> > conn.Open(strConn)
> >
> > strSQL = "select count(*) as quantity, gender "
> > strSQL = strSQL & "from person "
> > strSQL = strSQL & "group by gender;"
> >
> > Response.Write strSQL & "<BR>"
> >
> > Set Rs = conn.Execute(strSQL)
> >
> > While Not Rs.EOF
> > Response.Write "Quantity: " & RS("quantity") & " - Gender: " &
> > RS("gender") & "<BR>"
> > Rs.MoveNext
> > Wend
> >
> > Rs.Close
> > conn.close
> > response.write "The End<br>"
> > %>
> > </body>
> > </html>
> >
> > *** The page above should print:
> > Begin
> > select count(*) as quantity, gender from person group by gender;
> > Quantity: 2 - Gender: f
> > Quantity: 3 - Gender: m
> > The End
> >
> > *** Instead, I'm getting this:
> >
> > Begin
> > select count(*) as quantity, gender from person group by gender;
> > The End
> >
> > *** It means that the record set is empty.
> >
> > Thank you very much for any help.
> >
> > Regards,
> >
> > Celso.
> >
_________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
