SalesCart Standard / PRO / SQL - Ascending by order #

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: November/23/24 at 8:47pm
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; "