# HG changeset patch # User Matti Hamalainen # Date 1613471407 -7200 # Node ID 5260156d95210183e6edec1a14aeec7b6a11a3ca # Parent 2f62fa434056e3752fca77371d8f24102f6084e3 tj: Oops, forgot to use LIKE instead of '=' here for comparing uid. Fixed. diff -r 2f62fa434056 -r 5260156d9521 tj.tcl --- a/tj.tcl Tue Feb 16 12:29:36 2021 +0200 +++ b/tj.tcl Tue Feb 16 12:30:07 2021 +0200 @@ -471,7 +471,7 @@ set uid $tj_default_id } else { # Check if a TJ exists with this id? - set usql "SELECT COUNT(*) FROM tj WHERE uuser='[utl_escape $uhand]' AND uid='[utl_escape $uid]'" + set usql "SELECT COUNT(*) FROM tj WHERE uuser='[utl_escape $uhand]' AND uid LIKE '[utl_escape $uid]'" if {[catch {set nids [tj_dbh onecolumn $usql]} uerrmsg]} { tj_msg $upublic $unick $uchan "err_sql" [list $uerrmsg] tj_log "$uerrmsg on SQL:\n$usql"