Have you tried to run the query in MySQL's console? - Carsten
> -----Oprindelig meddelelse----- > Fra: Rob Galvin [mailto:[EMAIL PROTECTED]] > Sendt: 30. maj 2002 20:29 > Til: [EMAIL PROTECTED] > Emne: ADO recordset is not returning rows in ASP page > > > I have an active server page using an ADO recordset. When the SQL > command is > a join of two tables with a count/group by there are no records being > returned (RS.EOF is true). <snip> > If I do the same query from from MS Access using the same ODBC DSN, I get > results. So it is not an ODBC problem. If I do the query without the > count(*)/group by joing the two tables then it is ok. If I do a > count(*)/group by on a single table it is ok. --------------------------------------------------------------------- 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
