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

[Jesse P. <je...@st...>]

Chris found his problem and fixed it....
=20
jesse
=20
=20
-----Original Message-----
From: skaill [mailto:sk...@ro...]
Sent: Monday, September 27, 2004 2:51 PM
To: web...@li...
Subject: Re: [Web-erp-developers] SelectProduct.php


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...
=20
Steve
----- Original Message -----=20
From: Jesse  <mailto:je...@st...> 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?
=20
=20
jesse
=20
-----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 =
<http://nse.encore-inc.com/>=20
=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