Menu
▾
▴
RE: [Web-erp-developers] SelectProduct.php
|
From: Chris B. <cb...@en...> - 2004-09-27 19:11:15
|
Yeah I Fixed it. For some reason it would not take the SQL to update the LocStock until the 4th time. -----Original Message----- From: web...@li... [mailto:web...@li...] On Behalf Of skaill Sent: Monday, September 27, 2004 1: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... Steve ----- Original Message ----- From: Jesse Peterson <mailto:je...@st...> To: web...@li... 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 -----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. |
