Select Statement

When I run this query I get an error of:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CatCode='.

/projectli/ass1/managehomes.asp, line 79

The query is listed below:

objRS.open "Select * FROM Choice WHERE CatCode=" & taste

Can you help me please

You might have to enclose the CatCode variable in '

e.g

VB Code:

objRS.open "Select * FROM Choice WHERE CatCode='" & taste & "'"

Cheers
Markus

OR

your "taste" variable is empty.
check it by typing

response.write "taste value =" & taste
response.end

in front of your sql statement.