Re: Problem with inserting NULL values.

2003-08-01 Thread Ronald J Kimball
On Fri, Aug 01, 2003 at 09:03:21AM -0500, Igor Korolev wrote: > Actually, there are quite a few messages about this in the group > archive. Just search for "NULL". > > You need to pass the third parameter -- {type => SQL_CHAR} to > bind_param method (see DBI perldoc). Otherwise, the driver > str

Re: Problem with inserting NULL values.

2003-08-01 Thread Keith C. Ivey
On 1 Aug 2003 at 9:36, Ronald J Kimball wrote: > On Fri, Aug 01, 2003 at 03:27:47PM +0200, Andreas.Mock wrote: > > > Then, if I provide a null value as 'undef'(sure without quotes) to a > > bind variable the String 'null' gets inserted to the database table. > > But I want a real NULL value. I can

RE: Problem with inserting NULL values.

2003-08-01 Thread Igor Korolev
ginal Message- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 8:37 AM To: Andreas.Mock Cc: [EMAIL PROTECTED] Subject: Re: Problem with inserting NULL values. On Fri, Aug 01, 2003 at 03:27:47PM +0200, Andreas.Mock wrote: > 2) preparing insert statement is ok. > T

Re: Problem with inserting NULL values.

2003-08-01 Thread Ronald J Kimball
On Fri, Aug 01, 2003 at 03:27:47PM +0200, Andreas.Mock wrote: > 2) preparing insert statement is ok. > Then, if I provide a null value as 'undef'(sure without quotes) > to a bind variable the String 'null' gets inserted to the database > table. But I want a real NULL value. I can't understand this