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

As long as the value in $abc is undef it will be fine. It's only the 
value that matters, not the symbol.

Your system should have perl documentation installed. If it doesn't, 
stop right now and get the docs. that's where I got the info from, not 
from a URL.

cheers

andrew

Harpreet Dhaliwal wrote:
> Actually the thing is that sometimes the value can be null and 
> sometimes it can have a value depending.
> How should I take care of this situation.
>
> I mean $abc can and can't be null.
> Simple passing undef for it would mean a null value being pased and i 
> think the code would for a situation when it doesn't have a null 
> value. Right?
>
> Also, can you please copy paste the URL where from u gave me the 
> previous info?
>
> Thanks,
> ~Harpreet.
>
> On 1/22/07, *Andrew Dunstan* < [email protected] 
> <mailto:[email protected]>> wrote:
>
>
>     perldoc DBI says:
>
>            NULL Values
>
>            Undefined values, or "undef", are used to indicate NULL
>     values.  You
>            can insert and update columns with a NULL value as you would a
>     non-NULL
>            value.  These examples insert and update the column "age"
>     with a NULL
>            value:
>
>              $sth = $dbh->prepare(qq{
>                INSERT INTO people (fullname, age) VALUES (?, ?)
>              });
>              $sth->execute("Joe Bloggs", undef);
>
>              $sth = $dbh->prepare(qq{
>                UPDATE people SET age = ? WHERE fullname = ?
>              });
>              $sth->execute(undef, "Joe Bloggs");
>
>
>     cheers
>
>     andrew
>
>     Harpreet Dhaliwal wrote:
>     > can you please give me some quick pointers in dbi docs?
>     > thanks,
>     > ~Harpreet
>     >
>     > On 1/22/07, *Andrew Dunstan* <[email protected]
>     <mailto:[email protected]>
>     > <mailto:[email protected] <mailto:[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
>     >
>     >
>
>