|
|
|
|
|
Post Reply 
|
| Author | |
wscharen 
Newbie 
Joined: March/17/05 Location: United States Status: Offline Points: 15 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Prod Mgt-way to sort table of displayedPosted: 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! 
|
|
 |
|
|
Techno Geek
Admin Group 
Evil monkey living in my closet! Joined: March/11/04 Location: United States Status: Offline Points: 1206 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
wscharen
Newbie
Joined: March/17/05 Location: United States Status: Offline Points: 15 |
Post Options
Thanks(0)
Quote Reply
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, |
|
|
|
|
Techno Geek
Admin Group
Evil monkey living in my closet! Joined: March/11/04 Location: United States Status: Offline Points: 1206 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
wscharen
Newbie
Joined: March/17/05 Location: United States Status: Offline Points: 15 |
Post Options
Thanks(0)
Quote Reply
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! |
|
|
|
|
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 |
Prod Mgt-way to sort table of displayed
Topic Options