Posted by Oli Filth on 09/28/05 15:55

Stefan Rybacki said the following on 28/09/2005 12:43:
> Oli Filth wrote:
>
>> s4femod3 said the following on 28/09/2005 04:05:
>>
>>> y not try odbc_num_rows($query); ?
>>>
>>> this function will return the number of rows in an ODBC result. This
>>> function will return -1 on error. For INSERT, UPDATE and DELETE
>>> statements odbc_num_rows() returns the number of rows affected. For a
>>> SELECT clause this can be the number of rows available.
>>>
>>
>> Alternatively, why not include a COUNT(*) in your SELECT query?
>>
> I don't think that this is working, since as soon as you have a count(*)
> in your SELECT clause, the query returns just one row (if you didn't use
> group by, but in this case the count function won't help anyway)
>

Oh yes, you're absolutely right! Silly me. ;) I guess you could execute
a SELECT COUNT(*)... query to get the row count before the actual SELECT
query itself.

--
Oli

• Next in forum: Re: how to move into a recordset?
• Prev in forum: Re: how to move into a recordset?
• Thread view: Re: how to move into a recordset?

[Reply to this message]