Can someone plizz help me out and tells me wha tis wrong with this statement ???
I am lost (Online validators says it is an error in this statement, at work I get the desired results with no errors but at home on my IIS server it throws an error)
Code:
SELECT dtePostDate, intCatID, intPostBy, intPostID, memPostContent, txtPostTitle, txtNickName, st_knjig, imeslike FROM tblBlog, tblUsers WHERE bitPostShow = " + Replace(Recordset1__MMColParam, "'", "''") + " AND tblBLog.intPostBy = tblUsers.intUserID AND dtePostDate > #" + Replace(Recordset1__MMColParam2, "'", "''") + "# AND tblBLog.intCatID LIKE '" + Replace(Recordset1__MMColParam3, "'", "''") + "' AND memPostContent LIKE '%" + Replace(Recordset1__MMColParam4, "'", "''") + "%' ORDER BY dtePostDate DESC