Hi! This query is working just fine in any MySQL client: SELECT Count(*) AS CountOfOffice , Office FROM mytable GROUP BY Office But it returns no data in ASP pages. My guess is that there is a bug in the MyODBC. I'm using an IIS 4.0 web server connected to a MySQL installed on another windows machine. thank you in advance. George ========================================= George LAZAR SYSTEM Development Manager RASDAQ STOCK EXCHANGE Bucharest, Romania E-mail: [EMAIL PROTECTED] Tel: 310.49.29, 310.49.30, 310.49.31 Fax: 310.49.32 Web: www.rasd.ro =========================================
