rs.Open "SELECT * FROM ratings WHERE Ip='" & visitorIP & "' AND TeamName=" & TeamName
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Ip='66.77.7777' AND TeamName=St George'.
The IP is correct I just changed it here
The error points to the sql statement
What is the missing operator in the statement?
If I choose any other choice out of the drop down menu to add to the database I get this.
Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
The field and table names are correct.
This points to the sql statement also
Edited by choshour
Topic Options
Post Options
Thanks(0)
