Asp.net cofcms website content management system, debugging records

I. Reasons for endless homepage Loops. Different access and SQL syntaxes lead to exceptions when displaying advertisements.

Select Id, Aid, Title, StartTime, EndTime, AdUrl, LinkUrl, AdRemark, IsLock, AddTime FROM Adbanner
Where IsLock = 0 and datediff (day, StartTime, getDate ()> = 0 and datediff (day, EndTime, getDate () <= 0 and Aid = 1

Datediff (day, StartTime, getDate ()> = 0 to determine whether the specified date has passed, datediff (day, EndTime, getDate () <= 0 to determine whether the specified date has expired.

The reason for the cms endless loop is that access and SQL syntax are different, resulting in exceptions. The following is the access Syntax:

Select Id, Aid, Title, StartTime, EndTime, AdUrl, LinkUrl, AdRemark, IsLock, AddTime
FROM Adbanner where IsLock = 0 and datediff ('D', StartTime, now ()> = 0 and datediff ('D', EndTime, now ()) <= 0 and Aid = 1

Ii. Reasons for endless background logon pages. <Script type = "text/javascript" src = "js/focus. js"> </script> references this js file, leading to an endless page loop and unknown reasons. This js file is not found in the project.

You can delete this reference to run properly.

 

 

From column BQL_Email