Amount qualifiers in ODBC

[mr_zog]

Does anyone know if "=<" and ">=" work in ODBC queries. I am quering a MSSQL DB and it does return an error and resturns all of the results.

Thanks.

[Lars_Berg]

use <= and >=

It has nothing to do with ODBC. If yuo still have problems, show the sql statement and the error you get.

[mr_zog]

here is the SQL statement

$query="SELECT PrevReadDate, PrevRead, CurrReadDate, CurrRead, ReadType, Usage, AddlUsage, History.InvoiceNo from Readings, History where Readings.AccountKey=$accountkey and CurrReadDate>=$moveindate and History.AccountKey=Readings.AccountKey and History.ReadKey=Readings.ReadKey and History.InvoiceNo like 'WC%' order by CurrReadDate desc";

There is no errors but it returns ALL the rows that match, not the ones that have CurrReadDate greater than or equal to the Moveindate.

Any ideas?

[Lars_Berg]

CurrReadDate>= '$moveindate' 

Your query is comparing numerical values not dates.