| # | A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | Q | R | S | T | U | V | W
Software error:
select count(*) ct
from ctsrp.pr_projectmaster
where project_type in ('Departmental Research', 'Other Dept Research', 'CTS Research', 'CTS Education', 'CTS Outreach')
and m.authorizationdate is not null
and m.contractstatus != 'Project Cancelled'
group by substr((case
when substr((NVL(upper(displaytitle), upper(projecttitle))), 1, 2) = 'A '
then substr(NVL(displaytitle, projecttitle), 3)
when substr(NVL(upper(displaytitle), upper(projecttitle)), 1, 3) = 'AN '
then substr(NVL(displaytitle, projecttitle), 4)
when substr(NVL(upper(displaytitle), upper(projecttitle)), 1, 4) = 'THE '
then substr(NVL(displaytitle, projecttitle), 5)
when substr(NVL(upper(displaytitle), upper(projecttitle)), 1, 1) in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
then '#'
else
NVL(displaytitle, projecttitle)
end), 0, 1)
order by min(projecttitle)
ORA-00904: "M"."CONTRACTSTATUS": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 259 in 'select count(*) ct
from ctsrp.pr_projectmaster
where project_type in ('Departmental Research', 'Other Dept Research', 'CTS Research', 'CTS Education', 'CTS Outreach')
and m.authorizationdate is not null
and <*>m.contractstatus != 'Project Cancelled'
group by substr((case
when substr((NVL(upper(displaytitle), upper(projecttitle))), 1, 2) = 'A '
then substr(NVL(displaytitle, projecttitle), 3)
when substr(NVL(upper(displaytitle), upper(projecttitle)), 1, 3) = 'AN '
then substr(NVL(displaytitle, projecttitle), 4)
when substr(NVL(upper(displaytitle), upper(projecttitle)), 1, 4) = 'THE '
then substr(NVL(displaytitle, projecttitle), 5)
when substr(NVL(upper(displaytitle), upper(projecttitle)), 1, 1) in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
then '#'
else
NVL(displaytitle, projecttitle)
end), 0, 1)
order by min(projecttitle)') at /usr/lib/perl5/site_perl/5.8.5/JAWS/DB.pm line 124
JAWS::DB::get('JAWS::DB=HASH(0x95f0698)', 'select count(*) ct\x{a} from ctsrp.pr_projectmaster\x{a} ...') called at /hotel/ctsweb/www.cts.umn.edu/docs/Research/browse.pl line 89
For help, please send mail to the webmaster (cts@software.umn.edu), giving this error message and the time and date of the error.