![]() |
Page Navigation - Brand |
Post Reply ![]() |
Author | |
knifepro ![]() Newbie ![]() Joined: 18-February-2008 Location: United States Status: Offline Points: 9 |
![]() ![]() ![]() ![]() ![]() Posted: 20-February-2008 at 11:02am |
I would like to include to a Shop By Brand list on all my pages like the Browse by Category list? The Shop by Brand could be a drop-down menu or a full list. Has anyone else added a menu like this. If so I would appreciate the code help. I am new to ProductCart. |
|
Brian
brian@theknifeprofessional.com brian@heartlandbraidedrugs.com www.theknifeprofessional.com www.heartlandbraidedrugs.com ProductCart v4.7 QuickBooks Sync Mobile |
|
![]() |
|
Greg Dinger ![]() Certified ProductCart Developers ![]() ![]() Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
![]() ![]() ![]() ![]() ![]() |
Preparing such a list is as simple as opening a recordset, looping through the records and writing the code in the form you desire (Assuming you want it dynamic.) If you are comfortable with ASP scripting, viewbrands.asp would be a good page to reference for constructing such a module. Or a developer could build that for you. Alternatively, a hard-coded dropdown would also be easy to code. You would have to maintain it when the available brands change, but the code would be fairly simple.
|
|
![]() |
|
knifepro ![]() Newbie ![]() Joined: 18-February-2008 Location: United States Status: Offline Points: 9 |
![]() ![]() ![]() ![]() ![]() |
I got the brand list to appear and link to the correct brand but if you click on a Brand that does not have any products then I get an error message in the brand list. Here is the code I am using. Any suggestions:
My development site is located at: http://208.75.248.150/store/pc/home.asp. I am new to ASP. I am using MS SQL database. Do anyone see a problem with over taxing the database? I will have about 80 brands. |
|
Brian
brian@theknifeprofessional.com brian@heartlandbraidedrugs.com www.theknifeprofessional.com www.heartlandbraidedrugs.com ProductCart v4.7 QuickBooks Sync Mobile |
|
![]() |
|
netprofits ![]() Certified ProductCart Developers ![]() Joined: 05-January-2006 Location: United States Status: Offline Points: 22 |
![]() ![]() ![]() ![]() ![]() |
Whenever you're doing something like this where the ASP code needs to run on every page of the site to load information from the database (i.e. its in the header file), we recommend moving that code into the control panel and only running the routine when you modify your brands. You would create a new ASP page in the control panel that creates your HTML list and writes it out to an HTML include file. Then your header.asp file would just include the brands list include file. This is the same concept behind the Product Cart "Generate Navigation" function. It increases performance of each page and decreases load on your database. You could review the pcadmin/gencatnavigation.asp to see how it does this. |
|
![]() |
|
Greg Dinger ![]() Certified ProductCart Developers ![]() ![]() Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
![]() ![]() ![]() ![]() ![]() |
Dan - I explained the alternatives (the approach he has implemented versus generating an include file) to him yesterday when he asked me to bid the project. The one thing he missed was to close and destroy the recordset and db connection. Edited by Greg Dinger - 21-February-2008 at 4:03pm |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |