Mage33
Aug 30th, 2000, 06:39 PM
Any idea why this:
strSQL = "SELECT * "
strSQL = strSQL & "FROM t_events "
strSQL = strSQL & "WHERE " & inSTR 1,te_keywords,vKeyWords) > 0
strSQL = strSQL & " AND " & inSTR(1, te_region,vRegion) > 0
rs.Open strSQL
would give me a type mismatch (on the very first line)
strSQL = "SELECT * "
strSQL = strSQL & "FROM t_events "
strSQL = strSQL & "WHERE " & inSTR 1,te_keywords,vKeyWords) > 0
strSQL = strSQL & " AND " & inSTR(1, te_region,vRegion) > 0
rs.Open strSQL
would give me a type mismatch (on the very first line)