in reply to Re: Re: MySQL and Perl... Update record Prob
in thread MySQL and Perl... Update record Prob

Have you checked the value of $in{tax_id}?

e.g.

if ($in{tax_id} ne "") { warn "updating $username tax to $in{tax_id}"; $dbh->do (qq{ UPDATE reg_users SET tax_id = ? WHERE username = ? }, undef, $in{tax_id}, $username) || error("Error on +MySQL Update: $DBI::errstr"); } else { warn "Not updating tax_id for $username (\$in{new_aff} == $in{new_ +aff})"; }
If you don't see a warning then the code isn't be executed for some reason. If you do see a warning, then you'll know exactly what's going on.

rdfield

Replies are listed 'Best First'.
Re: Re: MySQL and Perl... Update record Prob
by powerhouse (Friar) on Feb 03, 2003 at 17:42 UTC
    Ok, I added the warn before each do statement, and I do see them in the error log.

    They all look right, but it is still not updating my database. Everything elses get's updated. I am wondering if they are just illegal names or something, to MySQL.

    Any other ideas?

    Richard.