Anybody in here works with Active Server Pages? I get an error with this SELECT command:

SELECT * FROM homes WHERE cmnprice >= price AND cmxprice <= price

*CMNPRICE and CMXPRICE are variables.
*PRICE is a field in my table.

The error I get:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Visual FoxPro Driver]SQL: Column 'CMNPRICE' is not found.