in reply to Re: Best way to check which field(s) was changed
in thread Best way to check which field(s) was changed
Well
my $dbquery eq "UPDATE table_name SET column_name=$inputUpdate[0] WHERE column_name=$input[1]";was just an example. So there is no error message to show you.
I wanted to find all of the the fields that were changed and put them in the 'SET' part of the query and all of the ones that didn't change in the 'WHERE' part.
That is what I meant by 'most accurate'. As opposed to putting just one field in the 'WHERE' section (unless all other fields where changed) just in case there where more than one row in that column with the same entry.
I don't know if you understand what I mean. I do appreciate your help though.
|
|---|