The record count does not always give you the correct result.
Try rs.movefirst followed by rs.movelast and then check the record
count.
Or stick the results in a grid and see what's there.
Andy
-----Original Message-----
From: Mark Mchugh [mailto:mark...@yahoo.com]
Sent: 16 November 2005 14:13
To: mysql list
Subject: SQL problem
Hi,
I am using the following code
Set hubsdb = OpenDatabase("", dbDriverComplete,
False,
"ODBC;DSN=mysqltest;UID=root;PWD=xli2310;Database=adjuster")
Set rs = hubsdb.OpenRecordset("select * FROM
personal WHERE general LIKE 'Personal%'",
dbOpenDynaset)
MsgBox (rs.RecordCount)
i get zero results back, but when i run the query in
the mysql control center, i get 10 results back.
when i change the above sql to "Select * from
personal" i get all the items from the table back.
strange?
is there a bug?
thanks
3 messages in com.mysql.lists.win32RE: SQL problem
