[thelist] RecordCount

[Chris Blessing]

Hi Paul-

If you want to get a value for the RecordCount property, you'll need to (if
you haven't already) get the ADOVBS constants file and include it in your
document.

1) download from here:
http://www.4guysfromrolla.com/webtech/faq/Beginner/faq7.shtml
2) include it at the top like this: <!--#include
virtual="/path/to/adovbs.inc"-->

Now you can use these constants to open the recordset like this:

set objRS = server.createobject("adodb.recordset")
objRS.open strQuery, adOpenStatic, adLockReadOnly
theCount = objRS.RecordCount
theRecords = objRS.getRows()
objRS.close
set objRS = nothing

By using the getRows() method, you can close the record set immediately and
just loop through that array (theRecords).  Check it out in detail here:
http://www.4guysfromrolla.com/webtech/tips/t053100-1.shtml

Also, you may want to explicitly state which fields you're requesting in
your query, rather than using *.  Performance is the issue there, as well as
the reliability of the order in which the fields are returned.  By
explicitly stating "select table.id, table.firstname..." you will guarantee
that you get the fields you need in order, and nothing more.

HTH!  Feel free to ask more about GetRows() if you haven't used it; it's a
GREAT way to work with records.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> Hi,
> 	I'm working on an extranet at the moment - I have several
> groups which
> contain documents - i would liek to count how many documents are contained
> in each group.
>
> Its an access database - the code i'm using is below - anyone
> know how I can
> do this?
>
> <%
> strQuery = "SELECT [tblGroupData].*, [tblGroups].* FROM
> [tblGroupData] INNER
> JOIN [tblGroups] ON [tblGroupData].[Gid] = [tblGroups].[Gid] WHERE
> [tblGroupData].[Uid] = "& Id &""
> 'response.write strQuery'
> Set objRS = objConn.Execute(strQuery)
> %>
>

	<snip/>

>
> cheers
>
> paul
>