Error on Page: /club/scripts/clubpers/view_clubpers_list.asp

Query String: NS=PUBLIC

Database Error: (-2147217900) Invalid column name 'pers_startdate'.

Source:


SQL:select * from vw_club_personnel where pers_club_id = 7633 and pers_active = 1 and pers_hide = 0 and ((pers_startdate is null and pers_enddate is null) or (pers_startdate is null and pers_enddate >= getdate()) or (pers_startdate <= getdate() and pers_enddate is null) or (pers_startdate <= getdate() and pers_enddate >= getdate())) order by pers_dept_display_seq, pers_dept_desc, pers_disp_seq, pers_lastname, pers_firstname