From e96168fccfc97e7eb3cceac8ec06daf20fa93928 Mon Sep 17 00:00:00 2001 From: sunsetsystems Date: Sun, 7 Jan 2007 16:14:16 +0000 Subject: [PATCH] fix for users sometimes not listed in dropdowns --- interface/fax/fax_dispatch.php | 2 +- interface/patient_file/summary/pnotes_full.php | 3 ++- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/interface/fax/fax_dispatch.php b/interface/fax/fax_dispatch.php index 44f4dd6fd..79cc31512 100644 --- a/interface/fax/fax_dispatch.php +++ b/interface/fax/fax_dispatch.php @@ -251,7 +251,7 @@ // Get the users list. $ures = sqlStatement("SELECT username, fname, lname FROM users " . - "WHERE active = 1 AND info NOT LIKE '%Inactive%' " . + "WHERE active = 1 AND ( info IS NULL OR info NOT LIKE '%Inactive%' ) " . "ORDER BY lname, fname"); ?> diff --git a/interface/patient_file/summary/pnotes_full.php b/interface/patient_file/summary/pnotes_full.php index 34ff73141..65c255b64 100644 --- a/interface/patient_file/summary/pnotes_full.php +++ b/interface/patient_file/summary/pnotes_full.php @@ -69,7 +69,8 @@ if ($noteid) { // Get the users list. The "Inactive" test is a kludge, we should create // a separate column for this. $ures = sqlStatement("SELECT username, fname, lname FROM users " . - "WHERE username != '' AND active = 1 AND info NOT LIKE '%Inactive%' " . + "WHERE username != '' AND active = 1 AND " . + "( info IS NULL OR info NOT LIKE '%Inactive%' ) " . "ORDER BY lname, fname"); ?> -- 2.11.4.GIT