Snitz Forums 2000 - LastPostLink And Redirect in topic.asp

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 DEV-Group

DEV Discussions (General)

LastPostLink And Redirect in topic.asp

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 2

James
Average Member

USA
539 Posts

Posted - 29 September 2002 : 14:32:46

It's in the mod w/o code forum. Shouldn't it be moved to the mod w/code forum.

*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/*

work mule
Senior Member

USA
1358 Posts

Posted - 29 September 2002 : 14:59:51

I had used the .Find method before, but I was trying to look for an alternative.

I'm just wondering, would the cursortype change from adOpenForwardOnly to something else when using the .Find method? I just wonder if by using your initial suggestion of searching through the array would be better than using the .Find method. The array method would at least be compatible with mySQL and it would release the recordset sooner.

some reading for anyone looking for more information...

ADO 2.7 API Reference - CursorType Property
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprocursortype.asp

Avoid ADO Find Frustration
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima00/html/find.asp

Paging Through Records from ASP
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnserv/html/server05222000.asp

Two Alternative Images
These were the two icons I used for my old mod.

First New Post (placed before the topic subject/name)

http://www.geocities.com/redwolf_games/snitz/firstnew.gif

Last Post (placed same as current icon)

http://www.geocities.com/redwolf_games/snitz/lastpost.gif

GauravBhabu
Advanced Member

4288 Posts

Posted - 29 September 2002 : 15:56:08

quote:
Originally posted by work mule II

I had used the .Find method before, but I was trying to look for an alternative.

I'm just wondering, would the cursortype change from adOpenForwardOnly to something else when using the .Find method? The array method would at least be compatible with mySQL and it would release the recordset sooner

adOpenStatic. I use the following statement to check if bookmarks are supported.

If rstRecords.Supports(adBookmark) then

I did not include the changes for mysql because I don't have means to test it for mysql. But I think it will work for mysql same way. someone can test it.

Page: of 2

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.71 seconds.