I have a sub which select 2 values from the user table changes the values
then does an update to return the changed values to the table.

This was working. I rebooted my machine now it is not working.

These 2 select statements bring return the right values.
my $current_rating = $ut->select(['DP_ImageRating'],{ Username => $cand_user })->fetchrow_array;
my $votes = $ut->select(['DP_ImageVotes'],{ Username => $cand_user })->fetchrow_array;

Then I display the values to the screen and run some math on the values then perform this update statement:

$ut->update( {DP_ImageRating => $new_average,
DP_ImageVotes => $votes},
{ Username => $cand_user});

The update does not update the values.

I tried removing the plugin...which delete the columns from the table. Resyncing the database. Reinstalling.

No joy.

I also tried:
echo > lsql_Users.def

then resyncing..... this fixed the last update problem I had... no joy.
The irritating thing is I can update all the other fields in the table.

Any ideas would be appreciated.

Gordon
=================
www.iuni.com - Custom Coding and Plugins
YouPlusMe.com - For a good time