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;