Re: mysql SQLSelect produces empty

["Ian M. Jones" <ian at imij dot co dot uk>]

mohamed safwat sadek said:
> using rb 5.5 mysql 4.1 SQLExecute working fine but SQLSelect produces
> empty  recored set
> i did as book saied so  (SQLExecute working fine) the record count is
> -1  when using sqlselect
> please help
>

Unfortunately the MySQL database plugin is not able to set the record count.

Instead, either do a "select count(*) as numrecs from blah where blah
blah" before running your real query, or loop through the record set and
keep count as you go.
Regards,
-- 
Ian
________________________________________
http://www.imij.co.uk
http://www.ianmjones.net (blog)



_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>