home list archives users mailing list
 

Subject: Re: Incorrect integer value: 'null' for column 'idt_diagnostico' at row 1

Date view Thread view Subject view Author view Attachment view

From: Mathias Brito (mathiasbrito@gmail.com)
Date: Aug 06, 2008 21:08

Did i found the solution?! i should use NULL insteand of null right? the
string is case sensitive, and the default value is NULL, all uppercase. Am i
right?

Cheers,
Mathias

2008/8/6 Mathias Brito <mathiasbrito@gmail.com>

> Hi folks, i had a problem when trying to execute an SQLParameterisedQuery,
> i intercepted the messages an got the information sent, everything looks
> ok.. but i receive the error
>
> Incorrect integer value: 'null' for column 'idt_diagnostico' at row 1
>
> So the parameters sent with the parameterised query looks this (it is
> trucated)...
>
> [truncated] <![CDATA[null,443,Mathias,M,... [truncated]
>
> The parameters are in CSV format. There is more parameters, and the number
> of it matches with the number of '?' in the query....
> the first null you see is the column 'idt_diagnostico'. Looks like ogsa-dai
> is making null a regular string!
> So the question is, how do i represent the null value?
> Or, am i doing something wrong?
>
> Thanks,
> Mathias
>

Date view Thread view Subject view Author view Attachment view