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

[Andrew Dunstan]

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