Re: [GENERAL] Double types

2012-09-18 Thread Chris Angelico
On Wed, Sep 19, 2012 at 7:25 AM, Hall, Samuel L (Sam) wrote: > > I have an application that writes an Excel Spreadsheet to postgres. For the > values that go in number fields, I check the Excel values for dbnull and set > the parameters to 0, like this: cmd.Parameters(9).Value = 0. Npgsql throws

[GENERAL] Double types

2012-09-18 Thread Hall, Samuel L (Sam)
I have an application that writes an Excel Spreadsheet to postgres. For the values that go in number fields, I check the Excel values for dbnull and set the parameters to 0, like this: cmd.Parameters(9).Value = 0. Npgsql throws an error "format specifier was invalid" If I do this: cmd.Parameter