Re: How to bind a null value while using insert statements

can you please give me some quick pointers in dbi docs?
thanks,
~Harpreet

On 1/22/07, Andrew Dunstan <[email protected]> wrote:
>
> Harpreet Dhaliwal wrote:
> > Hi,
> >
> > I have the following insert statement
> >
> > insert into abc (a,b,c) values (?,?,?);
> >
> > when i execute this insert (in perl) i get the following error
> >
> > Cannot bind a reference (ARRAY(0x925069c)) ((null))
> >
> > This is because value of column a is defined but null
> > So how should in bind null value in my insert statement?
> >
> >
>
> For a null value you pass undef - see the DBI docs.
>
> cheers
>
> andrew
>
>