Forum Home Forum Home > Legacy Products > SalesCart Standard / PRO / SQL
  New Posts New Posts RSS Feed - Ascending by order #
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedAscending by order #

 Post Reply Post Reply
Author
Message
dremer View Drop Down
Newbie
Newbie


Joined: April/04/04
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote dremer Quote  Post ReplyReply Direct Link To This Post Topic: Ascending by order #
    Posted: August/20/06 at 4:30pm
I have the order Management Plug-in and when you run a report, the completed orders are shown by decending order. The lastest order is always on the bottom of the page. I what the lastest order to show on top. Where do I put the ascending (ASC)sql query to show the lastest order on top of the page. I will need it for reorder2.asp page too.

Thanks for your help
Dave   
Back to Top
dremer View Drop Down
Newbie
Newbie


Joined: April/04/04
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote dremer Quote  Post ReplyReply Direct Link To This Post Posted: August/20/06 at 10:28pm
I did figure on how to make the summary reports to DESC order, but I can't figue it out on the reorder2.asp page. I don't know where to put the DESC sql statement on this page. Please help
Dave
Back to Top
mikeb View Drop Down
Admin Group
Admin Group
Avatar

Joined: March/17/04
Location: United States
Status: Offline
Points: 194
Post Options Post Options   Thanks (0) Thanks(0)   Quote mikeb Quote  Post ReplyReply Direct Link To This Post Posted: August/25/06 at 2:45pm
R you using FrontPage or Dreamweaver?
Back to Top
dremer View Drop Down
Newbie
Newbie


Joined: April/04/04
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote dremer Quote  Post ReplyReply Direct Link To This Post Posted: August/25/06 at 2:47pm
yes, I have Frontpage
Thanks
Dave
Back to Top
mikeb View Drop Down
Admin Group
Admin Group
Avatar

Joined: March/17/04
Location: United States
Status: Offline
Points: 194
Post Options Post Options   Thanks (0) Thanks(0)   Quote mikeb Quote  Post ReplyReply Direct Link To This Post Posted: August/25/06 at 2:59pm
Reorder2.asp is not in the order management.

Change this line
SQLStmt = SQLStmt & "' and " & EmailField & "='" & Email & "' and Order.OrderDate >= " & RetrieveDate & "; "

to:

     SQLStmt = SQLStmt & "' and " & EmailField & "='" & Email & "' and Order.OrderDate >= " & RetrieveDate & " Order By Order.OrderDate DESC; "

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