homepage Welcome to WebmasterWorld Guest from 54.211.73.232
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
keeping Track of most recently viewed products
whats the best way of keeping track of the most recently viewed products
topr8

WebmasterWorld Senior Member topr8 us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 838 posted 2:28 pm on Jul 30, 2003 (gmt 0)

this site running off an access databse not sqlserver.

there is a requirement to show the most recently viewed products (3)

what would be the best way to do this?

holding the info in cookies, or tracking the customer with db entries for each page visited and pulling the most recent from the db, but filtering out matching entries. - this would be handy as it could double up as a way of analysing visitor movement, but i'm worried about bloating the access db.

am thinking that the db solution would be marginally quicker than using cookies

 

gangstah

10+ Year Member



 
Msg#: 838 posted 6:51 pm on Jul 30, 2003 (gmt 0)

I think I would probably go with the DB route also. I guess that all depends on how much strain the db is already under from page hits and record requests.

smokin

10+ Year Member



 
Msg#: 838 posted 6:58 pm on Jul 30, 2003 (gmt 0)

IMO you should limit the number of connections made to an access db, so I would use cookies

topr8

WebmasterWorld Senior Member topr8 us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 838 posted 8:19 pm on Jul 30, 2003 (gmt 0)

thanks ... more unsure now!

smokin

10+ Year Member



 
Msg#: 838 posted 8:26 pm on Jul 30, 2003 (gmt 0)

sorry didn't mean to confuse you, just offering you my opinion ;o)

gangstah

10+ Year Member



 
Msg#: 838 posted 9:55 pm on Jul 31, 2003 (gmt 0)

The more I think about, the more I think smokin is right. Access is so bad for Web databases, the fewer hits the better. Go with the cookie.

aspdaddy

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 838 posted 7:53 pm on Aug 1, 2003 (gmt 0)

Are we talking about dynamic breadcrumbs?

This keeps track of the last 3 pages.

sub add_to_recent()
session("page3")= session("page2")
session("page2")= session("page1")
session("page1") = request.ServerVariables("URL")
end sub

cococure

10+ Year Member



 
Msg#: 838 posted 10:44 pm on Aug 3, 2003 (gmt 0)

I would use aspdaddy's subroutine and augment it with code to get rid of duplicates as well.

TheDave

10+ Year Member



 
Msg#: 838 posted 7:49 am on Aug 4, 2003 (gmt 0)

Nice idea actually :) A thought I had was if the product id is stored in a querystring, you could just use a "productX" cookie and set it to the product id, rather than the URL. That way you can request the cookie and grab the product straight from the db. :)

Access is evil but I still use it :P

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved