Thomas,
What is the connection string you are using?
Bruce
-----Original Message-----
From: Thomas Ekegren Christensen [mailto:[EMAIL PROTECTED]]
Sent: Tue, 28 August 2001 18:43
To: [EMAIL PROTECTED]
Subject: mySQL
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
---------------------------------------------------------------------
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
