Click to select recipient:        close <% // fill re-assign dropdown if (project > -1) { if (project == 0) { sql = @"select us_email from users where us_active = 1 and len(us_email) > 0 order by us_email"; } else { // Only users explicitly allowed will be listed if (btnet.Util.get_setting("DefaultPermissionLevel","2") == "0") { sql = @"select us_email from users where us_active = 1 and len(us_email) > 0 and us_id in (select pu_user from project_user_xref where pu_project = $pr and pu_permission_level <> 0) order by us_email"; } // Only users explictly DISallowed will be omitted else { sql = @"select us_email from users where us_active = 1 and len(us_email) > 0 and us_id not in (select pu_user from project_user_xref where pu_project = $pr and pu_permission_level = 0) order by us_email"; } } sql = sql.Replace("$pr", Convert.ToString(project)); DataSet ds_emails = dbutil.get_dataset(sql); foreach (DataRow dr_email in ds_emails.Tables[0].Rows) { Response.Write(""); Response.Write(dr_email["us_email"]); Response.Write(""); } } %>