MySQL: Search error

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic


   find:
    'Put in where cluases for the actual search
    strSQL = strSQL & _
    strSQLwhereDate & _
    strSQLwhereForum & _
    strSQLwhereMemSearch & _
    strSQLwhereKeywords
        
    'Check the permissions
    strSQL = strSQL & _
    "AND (" & strDbTable & "Topic.Forum_ID " & _
        "IN (" & _
            "SELECT " & strDbTable & "Permissions.Forum_ID " & _
            "FROM " & strDbTable & "Permissions " & strDBNoLock & " " & _
            "WHERE (" & strDbTable & "Permissions.Group_ID = " & intGroupID & " OR " & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & ") " & _
                "AND " & strDbTable & "Permissions.View_Forum=" & strDBTrue & _
        ")" & _
    ") "


re:

    'Put in where cluases for the actual search
    strSQL = strSQL & _
    strSQLwhereDate & _
    strSQLwhereForum & _
    strSQLwhereMemSearch & _
    strSQLwhereKeywords
        
    'Check the permissions
    strSQL = strSQL & _
    "AND (" & strDbTable & "Topic.Forum_ID " & _
        "IN ('" & _
            "SELECT " & strDbTable & "Permissions.Forum_ID " & _
            "FROM " & strDbTable & "Permissions " & strDBNoLock & " " & _
            "WHERE (" & strDbTable & "Permissions.Group_ID = " & intGroupID & " OR " & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & ") " & _
                "AND " & strDbTable & "Permissions.View_Forum=" & strDBTrue & _
        "')" & _
    ") "