den driller lidt

Set rs4 = Server.CreateObject("ADODB.RecordSet")
   
    strSQL = "SELECT * FROM cz_clans WHERE"
    strSQL = strSQL & " (game = '" & strGame & "')"
    strSQL = strSQL & " OR (game1 = '" & strGame & "')"
    strSQL = strSQL & " OR (game2 = '" & strGame & "')"
    strSQL = strSQL & " OR (game3 = '" & strGame & "')"
    strSQL = strSQL & " AND (Status = 'ok')"
      rs4.Open strSQL, myConn, 1, 3

den ignore Status = 'ok', ved ikke om det er sat rigtig ind