Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SelectProduct.php Search by Supplier Part Number
05-19-2021, 11:23 AM,
#2
RE: SelectProduct.php Search by Supplier Part Number
Is that an older file version? (it seems to be, not a big deal)

The latest file version has a search for SupplierStockCode, if it might help seeing those changes?

If so, have a look at the latest file, lines 688-737.

Also, the conditions at lines 594, 642 have an extra check. (a length check)

Try to use that as a possible start, and if more help may be need, please post another reply.

In your changes, I was confused about the NOT LIKE portion of the WHERE clause here?:
Code:
    WHERE stockmaster.stockid " . LIKE . " '%" . $_POST['StockCode'] . "%'
      AND stockmaster.stockid NOT LIKE '*%'
Reply


Messages In This Thread
RE: SelectProduct.php Search by Supplier Part Number - by TurboPT - 05-19-2021, 11:23 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)