Re: Data dump using perl with mysql won't update

2004-05-06 Thread Paul DuBois
At 15:02 -0700 5/5/04, [EMAIL PROTECTED] wrote: before I begin sorry for the cross post but i'm desperate The routine in question is below. It's pretty straight forward its a series of loops which basically matches the row then dumps data stored in hash ref into the DB. for some reason the script

Re: Data dump using perl with mysql won't update

2004-05-05 Thread smrtalec
> If you want them set to NULL using DBI, you have to bind undef to the > proper parameter. Is that what you're doing, or are you binding > something else, such as 0 or the empty string? > No the initial values in the DB are set to null, with the exception of one field. I'm trying to assign th

Data dump using perl with mysql won't update

2004-05-05 Thread smrtalec
before I begin sorry for the cross post but i'm desperate The routine in question is below. It's pretty straight forward its a series of loops which basically matches the row then dumps data stored in hash ref into the DB. for some reason the script runs with no errors (ran with strict) I can ve