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
>
>
