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