Try putting the fields on the left-side and variables on the right-side of the comparison:
SELECT * FROM homes WHERE price <= cmnprice AND price >= cmxprice
>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.
It's "my" world. You're just living in it.