Return to Home Page First District Health Unit: Regional Public Health Agency in North Dakota
Home 
Programs & Services
ERROR getDocuments(): DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and inactive = 'N' order by create_dt2 desc' at line 17 at e:\p13231\hosting\fdhu\www\html\cgi-bin/lib/dbo.pl line 2110. 
SELECT
					document_id,
					program_id,
					file,
					name,
					modify_by,
					lcase(date_format(modify_dt, '%c/%e/%y %l:%i %p')) as modify_dt,
					create_by,
					lcase(date_format(create_dt, '%c/%e/%y %l:%i %p')) as create_dt,
					create_dt as create_dt2,
					DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pp.program_id = p.program_id
			and p.inactive = 'N'
			order by p.inactive,' at line 11 at e:\p13231\hosting\fdhu\www\html\cgi-bin/lib/dbo.pl line 894.
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and STR_TO_DATE(concat(e.month, '/', e.day, '/', e.year), '%m/%d/%Y') >= CURDATE' at line 17 at e:\p13231\hosting\fdhu\www\html\cgi-bin/lib/dbo.pl line 2053.
update_no,
					inactive
				FROM
					document
				WHERE
					program_id = 
					and inactive = 'N'
				order by create_dt2 desc
select p.program_id, p.name, p.description, lcase(date_format(p.modify_dt, '%c/%e/%y %l:%i %p')) as modify_dt, lcase(date_format(p.create_dt, '%c/%e/%y %l:%i %p')) as create_dt, p.inactive, pp.parent_id from program p, program_parent pp where pp.parent_id = and pp.program_id = p.program_id and p.inactive = 'N' order by p.inactive, p.name
Error getProgramsByParent(): DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pp.program_id = p.program_id and p.inactive = 'N' order by p.inactive,' at line 11 at e:\p13231\hosting\fdhu\www\html\cgi-bin/lib/dbo.pl line 894.
select e.event_id, e.event_ty, e.day, e.month, e.year, e.hour, e.minute, e.subject, e.message, lcase(date_format(e.modify_dt, '%c/%e/%y %l:%i %p')) as modify_dt, lcase(date_format(e.create_dt, '%c/%e/%y %l:%i %p')) as create_dt, eg.inactive from event e, event_group eg, event_program ep where e.event_id = eg.event_id and ep.event_id = e.event_id and ep.program_id = and STR_TO_DATE(concat(e.month, '/', e.day, '/', e.year), '%m/%d/%Y') >= CURDATE() order by eg.inactive, e.year, e.month, e.day limit 5
ERROR: getFutureEventsByProgram() DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and STR_TO_DATE(concat(e.month, '/', e.day, '/', e.year), '%m/%d/%Y') >= CURDATE' at line 17 at e:\p13231\hosting\fdhu\www\html\cgi-bin/lib/dbo.pl line 2053.
Programs & Services
All Programs : Tobacco Prevention :


« Back to Programs

 

First District Health Unit • 801 11 Ave. SW • PO Box 1268 • Minot, ND 58702
Phone: 701-852-1376 • Fax: 701-852-5043 •

About this site: Website Design / Software Development: Albertson Consulting.