[Exception: Unable to get job list: Transaction (Process ID 99) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. SQL: SELECT post_id, host, job_id, company, url, title, created, city, state, postal, country, substring(description,1,500) as Description, salary, jobtype, category, start_date, end_date, cust_id, fee, priority, archive from tbl_job where host <> 'insiderjobboard' AND (start_date - 1 < GETDATE()) AND (end_date + 1 > GETDATE()) AND (description LIKE '%') AND (city LIKE '%') AND (archive = 'False') ]
IJB_Data.IJBData.tbl.job.getJobList(String keys, String location, String title, String category) +2646
InsiderJobBoard.results.loadData() +155
InsiderJobBoard.results.Page_Load(Object sender, EventArgs e) +24
System.Web.UI.Control.OnLoad(EventArgs e) +95
System.Web.UI.Control.LoadRecursive() +59
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678
|