http://forum.salescart.com/forum/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 00:13:35 +0000 Fri, 25 Aug 2006 14:59:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 forum.salescart.com/forum/RSS_post_feed.asp?TID=606 http://forum.salescart.com/forum/forum_images/web_wiz_forums.png http://forum.salescart.com/forum/ http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2146&title=ascending-by-order#2146 Author: mikeb
Subject: 606
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; "

]]> Fri, 25 Aug 2006 14:59:51 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2146&title=ascending-by-order#2146 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2145&title=ascending-by-order#2145 Author: dremer
Subject: 606
Posted: August/25/06 at 2:47pm

yes, I have Frontpage
Thanks
Dave]]> Fri, 25 Aug 2006 14:47:43 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2145&title=ascending-by-order#2145 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2144&title=ascending-by-order#2144 Author: mikeb
Subject: 606
Posted: August/25/06 at 2:45pm

R you using FrontPage or Dreamweaver?]]> Fri, 25 Aug 2006 14:45:51 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2144&title=ascending-by-order#2144 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2135&title=ascending-by-order#2135 Author: dremer
Subject: 606
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 ]]> Sun, 20 Aug 2006 22:28:26 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2135&title=ascending-by-order#2135 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2133&title=ascending-by-order#2133 Author: dremer
Subject: 606
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   ]]> Sun, 20 Aug 2006 16:30:50 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=606&PID=2133&title=ascending-by-order#2133