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
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.
Column=
