Re: [WebERP-developers] purchase orders error when select item

[Phil D. <ph...@lo...>]

I think I may have fixed this not long ago - I think it was because 
there had been paging previously but a new search left the paging 
unchanged. From memory it only occurred after browsing through an item 
search then doing another search ?
This was the diff

https://sourceforge.net/p/web-erp/code/6741/


Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 31/07/14 09:04, gilberto dos santos alves wrote:
>
> weberp on purchase orders when we select some item-class
>
>  PO_Items.php give this error:
>
> http://[our-environment-url]/erp4113/PO_Items.php?identifier=1234567890
>
> Error DB 1064 : Problema apresent.
>         You have an error in your SQL syntax; check the manual that 
> corresponds to
>         your MySQL server version for the right syntax to use near 
> '-255' at line xx
>         Falha SQL no DB : SQL que falhou foi (offset -255)
>
>
>     SELECT stockmaster.stockid, stockmaster.description, 
> stockmaster.units
>         FROM stockmaster INNER JOIN stockcategory ON 
> stockmaster.categoryid=stockcategory.categoryid
>         WHERE stockmaster.mbflag<>'D' AND stockmaster.mbflag<>'A' AND 
> stockmaster.mbflag<>'K'
>             AND stockmaster.mbflag<>'G' and stockmaster.discontinued<>1
>             AND stockmaster.stockid LIKE '%av311%' AND 
> stockmaster.categoryid='AV'
>             ORDER BY stockmaster.stockid LIMIT 255 OFFSET -255
>
> -- 
> gilberto dos santos alves
> +55.11.98646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers