Prod Mgt-way to sort table of displayed
Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=383
Printed Date: April/25/24 at 4:27pm
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com
Topic: Prod Mgt-way to sort table of displayed
Posted By: wscharen
Subject: Prod Mgt-way to sort table of displayed
Date Posted: July/21/05 at 12:09pm
|
Hi All,
I have the Pro version and Product Mgt of SalesCart. I know that the dynamic.asp is back filled from the database with the products based on the query. My question is: Is there a way in which a sort can be done before the display? We sell boxes and customers like to see the SKU's displayed by their size, which is in the description field. The SKU's are not sorting in an sort of order that I have been able to determine either. Any help greatly Apprecaited!  ------------- Wendy |
Replies:
Posted By: Techno Geek
Date Posted: July/21/05 at 4:51pm
|
Usually a query string looks like this:
SELECT * From [Table] ORDER BY [Column] ASC/DESC The product management query can be modified to do this. ------------- Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support |
Posted By: wscharen
Date Posted: September/27/05 at 8:27am
|
Ok, I understand the SQL statement and that it needs to be placed into the dynamic.asp BUT where within the file does the query string need to be placed?
I tried it in several places and either I got an error or nothing happened. Can someone help? Thank you, ------------- Wendy |
Posted By: Techno Geek
Date Posted: September/27/05 at 8:44am
|
It depends if you're using the product management for FrontPage or Dreamweaver. The code is never going to be the same but you should be able to search for the select statement and modify it. ------------- Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support |
Posted By: wscharen
Date Posted: September/27/05 at 9:13am
|
Thank you!
I was adding a new SELECT statement into the code instead of adding the ORDER BY to the SELECT statement. It works great! ------------- Wendy |