S
Scott
I've got a db that has a table called USERS that contains ip addresses for
each record. Below, I'm trying to select any user with an ip address equal
to the variable "usserIP". What are the proper quotes to use when using SQL
to compare a string variable to a text column?
The database is an Access 2000 database and I'm using ASP Classic.
CODE: ***********************
sSQL = "SELECT * FROM Users WHERE IP= " & "'" & userIP & "'"
each record. Below, I'm trying to select any user with an ip address equal
to the variable "usserIP". What are the proper quotes to use when using SQL
to compare a string variable to a text column?
The database is an Access 2000 database and I'm using ASP Classic.
CODE: ***********************
sSQL = "SELECT * FROM Users WHERE IP= " & "'" & userIP & "'"