|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
ASP Photo Album & RecordSet Counting Problems |
|
From: |
Harry Ragsdale |
|
Date: |
2/14/2001 3:06:24 PM |
|
IP: |
141.133.156.98 |
I have an ASP driven photo album on my website. All the info needed is stored in an MS Access 2000 database.
I need to write some code that would allow me to count the number of items in the particular database. I have tried using RecordCount but I always get a response of -1. I even set the cursor for my database to adOpenStatic and that didn't work.
The whole reason behind all of this is that I am trying to dynamically create the "Previous" and "Next" navigation buttons under the pictures so people can scroll through all of them.
My problem is telling the ASP not to place a "Previous" link on the first image page as there won't be a photo before it. The same applies for the last picture page. There won't be any photos after the last photo so I need to tell it NOT to add the "Next" link.
As for the rest of the pictures, they need a "Previous" and "Next" link.
You can check out how I am doing all this at the following URL: http://64.212.143.71/portfolio/photos/photos.html
Once at the URL, choose a band and it's all ASP from there.
PLEASE HELP ME!! |
Follow Up - Re: ASP Photo Album & RecordSet Counting Problems - Mark 2/15/2001 10:42:01 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
