On Fri, 2008-12-12 at 11:35 +0000, [email protected] wrote: > Quoting beamends <[email protected]>: > > I've just tried this, assuming "apply" means run the SQl using > > phpgadmin. > > > > I've changed the old VAT(17.5) 2200 on the chart, set the valid date to > > 30th Nov and created a new tax 2201 VAT(15). > > > > When I go to save the Tax page I get : > > > > DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "" > > > > Error! > > > > INSERT INTO tax (chart_id, rate, taxnumber, validto, > > pass, taxmodule_id) > > VALUES (?, ?, ?, ?, ?, ?) > > ERROR: invalid input syntax for integer: "" > > I got this too. I think that you just need to make sure that there is > a number in the "Number" and "Ordering" fields, for each row. I put 0 > in the former (I'm not sure what it's used for, but originally it had > nothing in it, and setting it to 0 hasn't made any obvious > difference), and 1 in the latter. > > Hth, > Another Richard
Thanks - no zero in the "Ordering" column was indeed the problem. Cheers Richard > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
