For an example let's say that I have clients in multiple countries and I want a list of the number of clients per country. In order to do this I would think a statment like:
select country, count(*) clients from addresses group by country would work just fine. I have have been working in VB on NT with odbc client 2.50.39.00. I have tried all of the cursor combinations that I could think of, but I still at a loss. Could there be a problem with the version of the client??? Thanks again Jake -----Original Message----- From: David Kramer [mailto:[EMAIL PROTECTED]] Sent: Friday, August 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 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=Booger, Count(*)=2??? If you provide a little more info I might be able to help here, if what I said above is true then maybe do something like this select foo, count(*) CNT from Table group by foo having CNT > 1; Not sure on the syntax though, but something along those lines... 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 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. If I try: select booger from nose group by booger It returns results with one or more records. Thanks for all of your help! Jake --------------------------------------------------------------------- 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