- see footer for list info -<
Hi all,
Probably a simple answer but it has eluded me for a couple of days. ColdFusion MX7/Dreamweaver 8.0.1/Access 2003/Win2k. Here is my SQL: SELECT tblSuppliers.SupplierName, tblH_IC.ICID, tblH_IC.YearsConsultancy, tblH_IC.NumberEmployees, tblH_IC.ServicesStrategy, tblH_IC.ServicesBPR, tblH_IC.ServicesFeasibility, tblH_IC.ServicesSystemProc, tblH_IC.ServicesProjMngmnt, tblH_IC.ServicesInfoAudit, tblH_IC.ServicesCompliance, tblH_IC.ServicesSecurity, tblH_IC.ServicesOther, tblH_IC.Description, tblSuppliers.Address1, tblSuppliers.Address2, tblSuppliers.Address3, tblSuppliers.Town, tblSuppliers.Postcode, tblSuppliers.Telephone, tblSuppliers.WWW, tblSuppliers.LastWebUpdate FROM tblSuppliers INNER JOIN tblH_IC ON tblSuppliers.SupplierID = tblH_IC.SupplierID WHERE (((tblSuppliers.LastWebUpdate)>=#10/15/2005#)) ORDER BY tblSuppliers.SupplierName; This works perfectly OK when I run the query in Access, i.e. it returns all the records from table tblH_IC where the date criteria for the LastWebUpdate field of tblSuppliers is met. It also works when I test the query in the recordset dialogue box within DW. However, when I paste the SQL into my CFM page and run it, the query seems to return every record from tblH_IC, i.e. it ignores the date criteria in tblSuppliers. The date criteria is 15th October 2005. Any suggestions gratefully received. Many thanks in advance. Roger Broadhurst _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -< - Forum provided by www.fusetalk.com -< - DHTML Menus provided by www.APYCOM.com -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
