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 the
.
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 have clients
, 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 the ADO object
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
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 the ADO object... Within your Count(*) Group by are you trying
to return a result set that contains a duplicate row count, i.e.