I have a strange problem, when I run the following SQL query: SELECT surname, Count(forename) FROM names GROUP BY surname;
If I run this in a mysql DOS box I get a correct result showing the surnames and the appropriate number of people with that surname. If I run this same query through ASP, either MS or ChiliAsp! I get an empty recordset. I do not believe the ASP is at fault as the query works perfectly when I connect to an MS Access database. MySql version is 3.23.38 If anyone has any ideas why this is happening, or how I can work around it then please could you let me know. Regards, John Harman Infotex (UK) Limited www.infotex.co.uk --------------------------------------------------------------------- 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