From 4f25eedf9065f28badf1e5e1df6c925062d8279e Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Fri, 8 Jul 2005 09:31:41 +0000 Subject: Bug 285695: [PostgreSQL] Username checks for login, etc. need to be case insensitive Patch By Max Kanat-Alexander r=LpSolit, a=justdave --- request.cgi | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'request.cgi') diff --git a/request.cgi b/request.cgi index bc5eefa9a..4c6e7600f 100755 --- a/request.cgi +++ b/request.cgi @@ -145,12 +145,14 @@ sub queue { # Filter results by exact email address of requester or requestee. if (defined $cgi->param('requester') && $cgi->param('requester') ne "") { - push(@criteria, "requesters.login_name = " . SqlQuote($cgi->param('requester'))); + push(@criteria, $dbh->sql_istrcmp('requesters.login_name', + SqlQuote($cgi->param('requester')))); push(@excluded_columns, 'requester') unless $cgi->param('do_union'); } if (defined $cgi->param('requestee') && $cgi->param('requestee') ne "") { if ($cgi->param('requestee') ne "-") { - push(@criteria, "requestees.login_name = " . SqlQuote($cgi->param('requestee'))); + push(@criteria, $dbh->sql_istrcmp('requestees.login_name', + SqlQuote($cgi->param('requestee')))); } else { push(@criteria, "flags.requestee_id IS NULL") } push(@excluded_columns, 'requestee') unless $cgi->param('do_union'); -- cgit v1.2.3-24-g4f1b