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

[Chris B. <cb...@en...>]

When I print the SQL it is using, copy it and put it in the mysql
command line, it works great
 
-----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
 
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??
 
jesse
 
-----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.
 
The web address to see this is http://nse.encore-inc.com
<http://nse.encore-inc.com/> 
 
Uname: test
Pass: test1
 
THIS IS A LIVE SYSTEM, Please do not mess around in here too much.  But
someone please check it out.