navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

.asp page/access database - slide show

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> .asp page/access database - slide show
Page: [1]
 
adavies

 

Posts: 42
From: Cincinnati, Ohio, USA
Status: offline

 
.asp page/access database - slide show - 9/7/2002 17:07:44   
I have an .asp page which connects to an Access database and displays pictures ... a slide show. If you leave the .asp page and come back to it ...it does not start at the beginning of the slide show at picture #1 ... it seems to start randomly at any of the other pictures.

Is there any way to make sure that it starts at the first picture or record in the database every time one leaves and then comes back to the .asp page?

thanks

Ashley
bobby

 

Posts: 11394
Joined: 8/15/1969
From: Seattle WA USA
Status: offline

 
RE: .asp page/access database - slide show - 9/7/2002 17:10:45   
After opening the recordset use:

oRS.MoveFirst

Where oRS is the name of the recordset.

That will make sure the cursor moves to the first record of the recordset.



_____________________________

If con is the opposite of pro, is Congress the opposite of progress?


:)

(in reply to adavies)
adavies

 

Posts: 42
From: Cincinnati, Ohio, USA
Status: offline

 
RE: RE: .asp page/access database - slide show - 9/10/2002 8:04:42   
Bobby,
Does this go in the source code of my .asp page ? where?

thanks

Ashley

(in reply to bobby)
hhammash

 

Posts: 1064
Joined: 8/19/2002
Status: offline

 
RE: .asp page/access database - slide show - 9/10/2002 10:50:20   
Hi Ashley,

What is your .asp page? Is it made by ASP hard coding (full asp code) or was created by FrontPage?

If it is ASP coded, that line should go in your .asp page. After you define the RecordSet.

Example:
Dim objRS
set objRS=server.CreateObject(" ADODB.Recordset" )
ObjRS.open ......etc
ObjRS.MoveFirst

If the page is a FrontPage generated (DRW) from Access Database, I think it will go by default to the first record.

Is it possible to see the page. I am interested in the Slide show?!!!

Regards
Hisham

< Message edited by hhammash -- 9/9/2002 10:51:33 AM >

(in reply to adavies)
adavies

 

Posts: 42
From: Cincinnati, Ohio, USA
Status: offline

 
RE: RE: .asp page/access database - slide show - 9/10/2002 11:29:52   
yes..here is the slide show

http://www.bauscherconstruction.com/gallery/kitchens.asp

am trying to get it to reset to the beginning if you leave and then come back

thanks

Ashley

(in reply to hhammash)
hhammash

 

Posts: 1064
Joined: 8/19/2002
Status: offline

 
RE: .asp page/access database - slide show - 9/10/2002 12:15:15   
Hi,

It is nice, but you are right. When I leave and come back I get the same picture I left. Even when I refresh.

Is the slide created using Frontpage DRW?

Thanks
Hisham

(in reply to adavies)
adavies

 

Posts: 42
From: Cincinnati, Ohio, USA
Status: offline

 
RE: RE: .asp page/access database - slide show - 9/10/2002 13:18:14   
yes the slide show is created using Frontpage DRW

any suggestions ?

thanks

Ashley

(in reply to hhammash)
bobby

 

Posts: 11394
Joined: 8/15/1969
From: Seattle WA USA
Status: offline

 
RE: .asp page/access database - slide show - 9/10/2002 13:21:57   
I think that the problem may be that the browser is going to cache the page, and return to that saved version when you click on the " back" button...

There are ways to set your page to " time-out" immediately after the first load using ASP, but I don' t remember how to do it. That would force the page to automatically start over with each visit...

You could also try a " no-cache" meta tag in the page to see if that helps...

_____________________________

If con is the opposite of pro, is Congress the opposite of progress?


:)

(in reply to adavies)
hhammash

 

Posts: 1064
Joined: 8/19/2002
Status: offline

 
RE: .asp page/access database - slide show - 9/10/2002 14:45:52   
Hi,

How are you photos displayed on the Web?

- are they embedded in the database?
- are they linked in the database?
- are their path mentioned in the database field then linked via frotnpage field paramters?

Thanks
Hisham

(in reply to adavies)
adavies

 

Posts: 42
From: Cincinnati, Ohio, USA
Status: offline

 
RE: RE: .asp page/access database - slide show - 9/10/2002 15:04:39   
I tried both of Bobby' s suggestions above and neither one worked for me.

To answer your question...the path to a picture is mentioned in the database field then linked via frotnpage field paramters?

any ideas anybody ?

thanks

Ashley

(in reply to hhammash)
adavies

 

Posts: 42
From: Cincinnati, Ohio, USA
Status: offline

 
RE: RE: .asp page/access database - slide show - 9/13/2002 16:50:40   
Bobby,
I am still stumped on this....do you know how I can reset the slide show to the first record if I am using frontpage DRW to develop my .asp page ?

thanks

Ashley

(in reply to bobby)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> .asp page/access database - slide show
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts