BUG: Manager / View Orders By Month Cannot Display More Than One Page of Orders

ID: Q216588

The information in this article applies to:

Microsoft Site Server version 3.0, Commerce Edition

SYMPTOMS

When viewing orders by month with a Site Server Commerce 3.0 site, only a single page of orders can be viewed. This will be true only if the orders being viewed are not for the current month. If this is the case, selecting the next record (>) or next page (>>) buttons displays the first page of records for the current month.

CAUSE

The Active Server Pages (ASP) page Order_day.asp is used to display the results of the "View Orders By Month" query. Selecting the Update button on this page posts a query for orders associated with the specified month and year. The month and year are extracted from the HTTP post by the Date_args2var.asp ASP file and a SQL query is constructed. If more than a page of records exist, the next record (>) or next page (>>) buttons can be selected to view them. The next record (>) or next page (>>) buttons post a query based on a <form> contained in the List.asp file. This form does not include the month and year <INPUT> tags as did the initial post. When this post is processed by Date_args2var.asp, the lack of a posted month and year causes the month and year variables to be reset to the current month and year.

RESOLUTION

To work around this problem, the <FORM> contained in the List.asp file must include <INPUT> tags corresponding to the month and year initially specified. The following IMONTH and IYEAR Hidden tags should be added to this file.


<% End If %>
   <INPUT TYPE="Submit" NAME="list_PagingMove" VALUE=" Requery ">
   <INPUT TYPE="Hidden" NAME="ListAbsolutePage" VALUE="<% =<BR/>
           ListAbsolutePage %>">

    <INPUT TYPE="Hidden" NAME="IMONTH" VALUE="<%=imonth%>">
    <INPUT TYPE="Hidden" NAME="IYEAR" VALUE="<%=iyear%>">
...

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

Set the date on the server to a previous month and enter more than a page of orders.

Reset the date on the server to the correct date.

Using the MSPress30/manager pages, view the "Orders by Month" for the orders previously entered. You should find that more than a page of orders exist.

Select the next record or next page buttons. Orders for the current month will appear.

Additional query words:


Keywords          : prodsitesrv3 
Version           : winnt:3.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: March 31, 1999