Menard,
Friday, August 16, 2002, 8:44:38 PM, you wrote:
M> Me again
M> I found a work around to my problem:
M> select country, count(distinct client_name, client_address, etc..) clients
M> from addresses group by country
M> But I still don't understand why the below would not work. I downloaded
elp.
Help.
Thanks
Jake
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 5:26 PM
To: David Kramer; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Count and group by problems
For an example let's say that I
st 09, 2002 5:59 PM
To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED]
Subject: RE: Count and group by problems
Im not sure I understand what it is that you are trying to do here??? Im
assuming your using PERL/SomeScriptingLang on something on NT to connect to
mysql using
Interesting a spooky.
Try to use different cursor types. As you know, ADO,
or better said, OLE DB behaves (or misbehaves)
depending on the cursor. Have you tried a FORWARD and
READ ONLY cursor.
Good Luck
--- "Menard, Inc. Information Systems"
<[EMAIL PROTECTED]> wrote:
> Evening
>
> I think I'm
DK
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 3:10 PM
To: [EMAIL PROTECTED]
Subject: Count and group by problems
Evening
I think I'm losing my mind. I have a very simple query that works fine in
MySQLFront but will not wor
Evening
I think I'm losing my mind. I have a very simple query that works fine in
MySQLFront but will not work when I connect using ADO:
select booger, count(*) from nose group by booger
If I try the above query with one record It works fine. Once I try it with
more records, nothing returns.
I
