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 modify_dt desc' at line 16 at lib/dbo.pl line 2122.
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
FROM
document
WHERE
program_id =
and inactive = 'N'
ORDER BY modify_dt desc
|
