|
|
|
|
|
Post Reply 
|
| Author | |
dremer 
Newbie 
Joined: April/04/04 Status: Offline Points: 23 |
 Post Options
 Thanks(0)
 Quote Reply
 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 |
|
 |
|
|
dremer
Newbie
Joined: April/04/04 Status: Offline Points: 23 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
mikeb
Admin Group 
Joined: March/17/04 Location: United States Status: Offline Points: 194 |
Post Options
Thanks(0)
Quote Reply
Posted: August/25/06 at 2:45pm |
|
R you using FrontPage or Dreamweaver?
|
|
|
|
|
dremer
Newbie
Joined: April/04/04 Status: Offline Points: 23 |
Post Options
Thanks(0)
Quote Reply
Posted: August/25/06 at 2:47pm |
|
yes, I have Frontpage
Thanks Dave |
|
|
|
|
mikeb
Admin Group
Joined: March/17/04 Location: United States Status: Offline Points: 194 |
Post Options
Thanks(0)
Quote Reply
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; " |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Ascending by order #
Topic Options