Print Page | Close Window

Ascending by order #

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=606
Printed Date: March/28/24 at 10:39am
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com


Topic: Ascending by order #
Posted By: dremer
Subject: Ascending by order #
Date 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   



Replies:
Posted By: dremer
Date 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


Posted By: mikeb
Date Posted: August/25/06 at 2:45pm
R you using FrontPage or Dreamweaver?


Posted By: dremer
Date Posted: August/25/06 at 2:47pm
yes, I have Frontpage
Thanks
Dave


Posted By: mikeb
Date 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; "




Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.04 - http://www.webwizforums.com
Copyright ©2001-2015 Web Wiz Ltd. - http://www.webwiz.co.uk