Recordcount Problem

[Andrew Newton]

Hi

I have the following recordset query on my web site.

sql="SELECT * FROM tblNewsletterInfo WHERE NEWSLETTER_NUMERO=" & request("news") & " ORDER BY INFO_TRI, INFO_NUMERO"
set rs=server.createObject("adodb.recordset")
rs.open sql, conn, 3, 3
response.write(rs.recordcount)

When I connect to the Access db I get the correct recordcount.

However, when I change the connection to the Mysql db (that is identical to the access db) I get a recordcount of -1.

Does any one know why?

Thanks in advance.

Andrew