How can you select records for a FoxPro date by using date? The query:
<cfquery name="getpo" datasource="PO"> select ponumber, supplier,odr_date from purchase where odr_date > ''12/10/01" </cfquery> It returns with the error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch. In SQL, it works fine. But the DB will be in FoxPro When I select all and out the date, the date format is in yyyy-mm-dd. I tried using that format, but no luch either. Any clues? Thanks Jacob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
