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 rank asc, modify_dt desc' at line 17 at lib/dbo.pl line 2130.
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,
update_no,
inactive,
rank
FROM
document
WHERE
program_id =
and inactive = 'N'
ORDER BY rank asc, modify_dtDBD::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 lib/dbo.pl line 888.
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 18 at lib/dbo.pl line 2072.
desc
|
