>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.
You need to build your select string with the variable values not the variable name. Assuming numeric type here.
sql = "SELECT * FROM homes WHERE " & cmnprice & " >= price AND " & cmxprice & " <= price"
Michael McLain