Counting RecordSets....

courtjester · #1 Aug 27th, 2004, 20:02

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 · #2 Aug 27th, 2004, 21:14

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 · #3 Aug 28th, 2004, 03:47

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 · #4 Aug 28th, 2004, 08:31

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 · #5 Aug 28th, 2004, 22:18

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 · #6 Aug 29th, 2004, 08:44

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[need help-SEO]Counting no. of backlinks	RohanShenoy	Search Engine Optimization (SEO)	6	Feb 25th, 2008 06:51
Counting Instances in a table.	Pheonix	Databases	6	Mar 18th, 2006 22:16
PHP XML Counting Elements	Don Logan	PHP Forum	1	Mar 18th, 2006 03:03

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
Counting RecordSets....