Forum Home Forum Home > Legacy Products > SalesCart Standard / PRO / SQL
  New Posts New Posts RSS Feed - Prod Mgt-way to sort table of displayed
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedProd Mgt-way to sort table of displayed

 Post Reply Post Reply
Author
Message
wscharen View Drop Down
Newbie
Newbie
Avatar

Joined: March/17/05
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote wscharen Quote  Post ReplyReply Direct Link To This Post Topic: Prod Mgt-way to sort table of displayed
    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!
Back to Top
Techno Geek View Drop Down
Admin Group
Admin Group
Avatar
Evil monkey living in my closet!

Joined: March/11/04
Location: United States
Status: Offline
Points: 1206
Post Options Post Options   Thanks (0) Thanks(0)   Quote Techno Geek Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
wscharen View Drop Down
Newbie
Newbie
Avatar

Joined: March/17/05
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote wscharen Quote  Post ReplyReply Direct Link To This Post 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,
Back to Top
Techno Geek View Drop Down
Admin Group
Admin Group
Avatar
Evil monkey living in my closet!

Joined: March/11/04
Location: United States
Status: Offline
Points: 1206
Post Options Post Options   Thanks (0) Thanks(0)   Quote Techno Geek Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
wscharen View Drop Down
Newbie
Newbie
Avatar

Joined: March/17/05
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote wscharen Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.04
Copyright ©2001-2015 Web Wiz Ltd.

Copyright 2015 by ComCity® LLC and SalesCart™.  All Rights Reserved