Mercurial > hg > egg-tcls
changeset 636:c3911a8c28e5
tj: Oops, in 'set' command UPDATE clause we had forgotten to specify
uuser constraint when we converted to using uids instead of unique row ids.
Fixed.
| author | Matti Hamalainen <ccr@tnsp.org> |
|---|---|
| date | Tue, 16 Feb 2021 12:29:17 +0200 |
| parents | 4fbe70d3b63a |
| children | 2f62fa434056 |
| files | tj.tcl |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/tj.tcl Tue Feb 16 12:28:23 2021 +0200 +++ b/tj.tcl Tue Feb 16 12:29:17 2021 +0200 @@ -374,7 +374,7 @@ } if {[llength $usqlargs] > 0} { - set usql "UPDATE tj SET [join $usqlargs ,] WHERE uid LIKE '[utl_escape $uid]'" + set usql "UPDATE tj SET [join $usqlargs ,] WHERE uuser='[utl_escape $uhand]' AND uid LIKE '[utl_escape $uid]'" if {[catch {tj_dbh eval $usql} uerrmsg]} { tj_msg $upublic $unick $uchan "err_sql" [list $uerrmsg] tj_log "$uerrmsg on SQL:\n$usql"