Re: Again NULL Values

[Bryan Tolka]

I have tried all of the suggestion from you find folks. I am using 
mysql. The problem is updating several field with NULL or no values 
assigned. I hope i cna get this resolved.

Bryan Tolka


# check to see if oldip and ip do not match: delete old info
if ($ip ne $oldip){
    $sth = $dbh->prepare("update ipmgt set
            ip = '$oldip'
            hw = ,
            dnsName = ,
            userName = NULL,
            os= NULL,   
            dept= NULL,
            notes= NULL,
            bootType= NULL,
            bootFile= NULL,
            bootHost= NULL,
            where ip = '$oldip'");


    $sth = $dbh->prepare("update ipmgt set
            ip = '$ip',
            hw = '$hw',
            dnsName = '$dnsName',   
            userName = '$userName',
            os = '$os',
            dept = '$dept',
            notes = '$notes',
            bootType = '$bootType',
            bootFile = '$bootFile',
            bootHost = '$bootHost'
            where ip = '$ip'");

   



    $rc= $sth->execute;
    $sth->finish;
    $dbh->disconnect;
    system ("/usr/bin/logger -t web-ip-update -p local3.info IP update 
for $oldip changed to $ip, hw- $hw");
}
else {
    $sth = $dbh->prepare("update ipmgt set
            ip = '$ip',
            hw = '$hw',
            dnsName = '$dnsName',   
            userName = '$userName',
            os = '$os',
            dept = '$dept',
            notes = '$notes',
            bootType = '$bootType',
            bootFile = '$bootFile',
            bootHost = '$bootHost'

            where
            ip = '$ip'");
   
    $rc= $sth->execute;
    $sth->finish;
    $dbh->disconnect;
    system ("/usr/bin/logger -t web-ip-update -p local3.info IP update 
for $ip, hw= $hw");
}
}

>
>
>