Counting RecordSets....

[courtjester]

How do I go about doing this? Rob told me to do that but I couldn't figure it out. Is it objRS.Count or what? Also, been searching google and all I could really find on it is stuff about how the count messes up unless you count backwards... but not really any code for it. Any help would be much appreciated.

I'm trying to count objRS("ID") so that I can see on my details.asp page if the page exists or not. If the number is greater than the count then I give an "I'm sorry, this page does not exist". THanks.

[Rob]

are you referring to the recordcount property of the recordset object?

A simple objRS.RecordCount will return the number of records you have pulled with your SQL Select statement. If this returns zero, then you have no records. If it is not zero, then it holds a number equal to the number of records in the recordset (as the name suggests)

Was this what you meant?

[courtjester]

Ok, I'm having this problem. When I do as you stated above I get -1 . How can there be a -1 ? Any help/suggestions would be much appreciated.

[Rob]

Hi Court Jester....

You have to be using a cursor that will support this. adOpenStatic and adLockOptimistic are both cursor's that will return a recordcount. The cursor is specified when you call 'open'.

Does this make sense? If not, then please post your code.

[courtjester]

Here's my code... everytime I put a cursor type in I get an error... This is the base coding, how would I set the cursor types? (sorry, I'm not used to this style of coding.

Code: Select all

<%
dim objRS
dim objConn
dim x

objRS = recordSet
objConn = connectionToDatabase
x = request.querystring("ID")


Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout=60
objConn.Open "DSN=Mydatabase"

Set objRS = objConn.Execute("SELECT * FROM Page WHERE ID =" &x)
Response.Write(objRS.recordCount)

Response.Write(objRS("Content"))


objConn.close
Set objConn=Nothing

%>

[Rob]

use this as your code to open the recordset:-

Code: Select all

RS.Open "SQL Query Here", ConnectionObject, adOpenKeySet,adLockOptimistic

You will need to reference the adovbs.inc (ADO CONSTANTS) file to enable you to use the constants (eg. adOpenKeySet) by name, instead of meaningless numbers.

Better still, place this in a file called global.asa in your root dir:-

Code: Select all

<!-- METADATA NAME="Microsoft ActiveX Data Objects 2.6 Library" 
     TYPE="TypeLib" UUID="{00000206-0000-0010-8000-00AA006D2EA4} -->

The aboive includes a reference to the CDO Constants in the .dll directly and allows access to the constants on every ASP page in your site. I referenced version 2.6, because I'm sure you'll have at least that version... search google if you want the right code for a higher version.