Re: get number of rows selected

by andyk@[EMAIL PROTECTED] (Andrei Kovalevski) Apr 7, 2008 at 04:30 AM

This is a multi-part message in MIME format.
--------------090906070702000905030802
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

Take a look at SQLRowCount( 
http://msdn2.microsoft.com/en-us/library//ms711835.aspx
). You may note:

*/For other statements and functions, the driver may define the value 
returned in *RowCountPtr. For example, some data sources may be able to 
return the number of rows returned by a SELECT statement or a catalog 
function before fetching the rows./*

You may rely on this when using  psqlODBC or  ODBCng with buffering mode 
ON (default).

Adam M wrote:
> Generally you would do that with a count function instead of relying
> on something else.
>
> "select * from layer where visible = 1"
>
> so I guess "SELECT COUNT(*) FROM layer WHERE visible=1" would give you
> the answer.
>
> - Adam
>   
-- 
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 sup****t
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

--------------090906070702000905030802
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello,<br>
<br>
Take a look at SQLRowCount(
<a class="moz-txt-link-freetext"
href="http://msdn2.microsoft.com/en-us/library//ms711835.aspx">http://msdn2.microsoft.com/en-us/library//ms711835.aspx</a>
). You may note:<br>
<br>
<tt><b><i>For other statements and functions, the driver may define the
value returned in *RowCountPtr. For example, some data sources may be
able to return the number of rows returned by a SELECT statement or a
catalog function before fetching the rows.</i></b></tt><br>
<br>
You may rely on this when using&nbsp; psqlODBC or&nbsp; ODBCng with
buffering
mode ON (default).<br>
<br>
Adam M wrote:
<blockquote
 cite="mid:84b37b360804030930o1b771e47ib9082bf3cecb54f6@[EMAIL PROTECTED]
"
 type="cite">
  <pre wrap="">Generally you would do that with a count function instead
of relying
on something else.

"select * from layer where visible = 1"

so I guess "SELECT COUNT(*) FROM layer WHERE visible=1" would give you
the answer.

- Adam
  </pre>
</blockquote>
<pre class="moz-signature" cols="72">-- 
Andrei Kovalevski
PostgreSQL Replication, Consulting, Custom Development, 24x7 sup****t
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - <a class="moz-txt-link-freetext"
href="http://www.commandprompt.com/">http://www.commandprompt.com/</a>
</pre>
</body>
</html>

--------------090906070702000905030802--