ProductCart Shopping Cart Software Forums : Search By OrderID skips incomplete orders https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 04:52:51 +0000 Sun, 19 Feb 2006 02:34:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=122 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Search By OrderID skips incomplete orders : Works good here I used the version...]]> https://forum.productcart.com/search-by-orderid-skips-incomplete-orders_topic122_post367.html#367 Author: watercrazed
Subject: 122
Posted: 19-February-2006 at 2:34am

Works good here I used the version from amgqmp1]]> Sun, 19 Feb 2006 02:34:55 +0000 https://forum.productcart.com/search-by-orderid-skips-incomplete-orders_topic122_post367.html#367 <![CDATA[Search By OrderID skips incomplete orders : I agree and have always considered...]]> https://forum.productcart.com/search-by-orderid-skips-incomplete-orders_topic122_post362.html#362 Author: amgqmp1
Subject: 122
Posted: 17-February-2006 at 11:59am

I agree and have always considered this a bug as well.  When my staff performs a search for an order (by number) they should be presented with a complete listing.

I found the code you posted to be a good method, although, I used a slightly different (see below).

============================

Line 54 of resultsAdvanced.asp:

Changed the line from:

"query=query & " WHERE orders.idCustomer=customers.idCustomer AND orderStatus>1 AND idOrder LIKE '%" & _"

Change the line to:

"query=query & " WHERE orders.idCustomer=customers.idCustomer AND orderStatus>=0 AND idOrder LIKE '%" & _"

(Remove the quotes before using this code)

So far, it's working well for us...I'd love to hear feedback from anyone else that gives this a try.



Edited by amgqmp1 - 17-February-2006 at 12:00pm]]> Fri, 17 Feb 2006 11:59:16 +0000 https://forum.productcart.com/search-by-orderid-skips-incomplete-orders_topic122_post362.html#362 <![CDATA[Search By OrderID skips incomplete orders : This may be by design, or an oversight,...]]> https://forum.productcart.com/search-by-orderid-skips-incomplete-orders_topic122_post344.html#344 Author: dfinster
Subject: 122
Posted: 11-February-2006 at 12:04pm

This may be by design, or an oversight, but it's an issue for my clients - they consider it a bug. 

In the "Locate an order" page (invoicing.asp), if you search by Order ID, you cannot pull up incomplete orders, although the result page shows a purple ball legend in the header indicating that incomplete orders would be in the list.

I made the following change to resultsAdvanced.asp beginning at line 52:

===================
else
    tempqryStr=(int(tempqryStr) - scpre)
    ' Change WHERE clause to allow all orders when searching by Order ID.
    ' query=query & " WHERE orders.idCustomer=customers.idCustomer AND orderStatus>1 AND idOrder LIKE '%" & _
    query=query & " WHERE orders.idCustomer=customers.idCustomer AND idOrder LIKE '%" & _
    tempqryStr & "%' ORDER BY "& strORD &" "& strSort
end if
====================

Any reason this would cause other issues in the system?
]]> Sat, 11 Feb 2006 12:04:01 +0000 https://forum.productcart.com/search-by-orderid-skips-incomplete-orders_topic122_post344.html#344