AND ... OR

Osäker på datumet. Access + asp.

' ## LOAD ALL POSTS TO GUESTBOOK
FUNCTION funcLoadAllInGuestbook()
	' ## 2. QUESTION
	SQL = "SELECT g.intID, g.strName, g.dteCreated, g.strText, g.strSignature, g.intCounter, g.bolURL " _
	& ", ( SELECT COUNT(*) FROM comments c WHERE c.intGuestbookID = g.intID ) " _
	& " FROM [guestbook] g WHERE [b](g.bolView = TRUE OR " _
	& " g.dteCreated = format(g.dteCreated, 'short date') = #" & date() & "#)[/b] ORDER BY g.dteCreated DESC;"
response.write SQL
	set mySQL = Conn.Execute(SQL)
	IF NOT mySQL.EOF THEN application("myGuestbook") = mySQL.GetRows() ELSE application("myGuestbook") = ""
END FUNCTION

response.write =
SELECT g.intID, g.strName, g.dteCreated, g.strText, g.strSignature, g.intCounter, g.bolURL , ( SELECT COUNT(*) FROM comments c WHERE c.intGuestbookID = g.intID ) FROM [guestbook] g WHERE (g.bolView = TRUE OR g.dteCreated = format(g.dteCreated, 'short date') = #2005-10-26#) ORDER BY g.dteCreated DESC;