Re: [Web-erp-developers] SelectProduct.php

[skaill <sk...@ro...>]

When I go there now and search under "a" I get a list of parts but none =
have quantities.  In fact I get 286 pages of parts.  Possibly you've =
fixed or are still having trouble quantity-wise...

Steve
  ----- Original Message -----=20
  From: Jesse Peterson=20
  To: web...@li...=20
  Sent: Monday, September 27, 2004 12:44 PM
  Subject: RE: [Web-erp-developers] SelectProduct.php


  Well, then either several scripts are busted or weberp is looking at a =
different database than the one you are selecting from.... want to =
forward me (off list) the SelectProduct.php scripts you are using?


  jesse

    -----Original Message-----
    From: Chris Bice [mailto:cb...@en...]
    Sent: Monday, September 27, 2004 12:26 PM
    To: web...@li...
    Subject: RE: [Web-erp-developers] SelectProduct.php


    When I print the SQL it is using, copy it and put it in the mysql =
command line, it works great

    =20

    -----Original Message-----
    From: web...@li... =
[mailto:web...@li...] On Behalf Of =
Jesse Peterson
    Sent: Monday, September 27, 2004 11:08 AM
    To: web...@li...
    Subject: RE: [Web-erp-developers] SelectProduct.php

    =20

    I can't tell much just from the Interface except that it definitely =
looks like there are no Items... My first thought was that you may have =
busted the SelectProduct lookup, but then I would have expected to see =
something on the Inventory Status by Location report.

    You may want to double check the database it is working against. =
Have you manually gone into the database and had a look??

    =20

    jesse

    =20

      -----Original Message-----
      From: Chris Bice [mailto:cb...@en...]
      Sent: Monday, September 27, 2004 11:41 AM
      To: web...@li...
      Subject: [Web-erp-developers] SelectProduct.php

      OK.  I think Im about to have a freaking heart attack.  I have =
27,000 Items in the Database.  I have one Location.  I have =
corresponding LocStock Records for each StockMaster Item.  When I go to =
SelectProduct.php, no matter what I put it it wont return ANY PARTS.

      =20

      The web address to see this is http://nse.encore-inc.com

      =20

      Uname: test

      Pass: test1

      =20

      THIS IS A LIVE SYSTEM, Please do not mess around in here too much. =
 But someone please check it out.  =20