Hi mySQL,
I have a huge problem and unfortunately my Domain Hosting Services has no interest in
helping me. I am running mySQL with ASP and use a DSN-less call to connect to mySQL.
The problem is a little bit weird because running the query using phpmyadmin gives me
a perfect recordset. Running it in ASP using ADO returns an empty recordset. The MySQL
manual talks about setting the option flag "return matching rows". Since I haven't got
the faintest idea of how to do this, I assume that's the reason for my empty recordset.
Can anyone please tell me how to do this and preferable using a DSN-less call to MySQL.
Kind regards,
Thomas Christensen
NB! The SQL query is listed below.
strSQL = "SELECT COUNT(Bog.Bogid), Brugere.Navn FROM Brugere INNER JOIN Bog ON
Bog.mailadresse = Brugere.mailadresse GROUP BY Brugere.Navn"
objRs.CursorLocation = adUseClient
objRs.Open strSQL, strConnect, adCmdText
---------------------------------------------------------------------
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