I have code that contains select stmts. The select stmts' where clauses are appended with DOZENS (HUNDREDS) of conditions. A select stmt can run fine for weeks and then break when a specific condition is choosen from web page.
ex. select e.name, e.employeeid, e.birthdate, c.name from employee , company .... if (filter on name) name = thename -error name not qualified s/b e.name = thename
How should this be handled/designed future/present?