CTS Home

Home > Publications > Research Reports > Reports by Title

# | 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.or_final_report
    where upper((case
			 when substr(upper(title), 1, 2) = 'A '
			  then substr(title, 3)
			 when substr(upper(title), 1, 3) = 'AN '
			  then substr(title, 4)
			 when substr(upper(title), 1, 4) = 'THE '
			  then substr(title, 5)
			 when substr(upper(projecttitle), 1, 1) in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
			  then '#'
			 else
			  title
			end)) = 'A' 
ORA-00904: "PROJECTTITLE": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 303 in 'select count(*) ct from ctsrp.or_final_report
    where upper((case
			 when substr(upper(title), 1, 2) = 'A '
			  then substr(title, 3)
			 when substr(upper(title), 1, 3) = 'AN '
			  then substr(title, 4)
			 when substr(upper(title), 1, 4) = 'THE '
			  then substr(title, 5)
			 when substr(upper(<*>projecttitle), 1, 1) in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
			  then '#'
			 else
			  title
			end)) = 'A' ') at /usr/lib/perl5/site_perl/5.8.5/JAWS/DB.pm line 124
	JAWS::DB::get('JAWS::DB=HASH(0x8796d18)', 'select count(*) ct from ctsrp.or_final_report\x{a}    where upper...') called at /hotel/ctsweb/www.cts.umn.edu/docs/Publications/ResearchReports/browse.pl line 74

For help, please send mail to the webmaster (cts@jaws.umn.edu), giving this error message and the time and date of the error.