Starting Position

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Starting Position

Logged in as: Guest

arrSession:exec spGetSession 2,3,33781

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Starting Position
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Starting Position - 4/22/2006 4:07:25 AM

divine

Posts: 2
Score: 0
Joined: 4/22/2006
Status: offline

Im pulling all the records from a db using:
Recordset1.Source = "SELECT * FROM Products WHERE Category ...... etc

but how do I set a starting position so I dont have to pull from the first record?

Post #: 1

RE: Starting Position - 4/24/2006 1:14:33 AM

ebgreen

Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline

I don't understand the question. Do you mean how do you exclude some records from your result set?

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to divine)

Post #: 2

RE: Starting Position - 4/24/2006 10:17:46 AM

divine

Posts: 2
Score: 0
Joined: 4/22/2006
Status: offline

I have a loop that pulls everything out of a table. It just starts at the first record and moves to the next. I want to start at the 15th record down and not the first.

(in reply to ebgreen)

Post #: 3

RE: Starting Position - 4/25/2006 1:30:33 AM

ebgreen

Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline

If it is an ADO record set, use the .AbsolutePosition property.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to divine)