- see footer for list info -<
Roger Broadhurst wrote:
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.
<cfqueryparam> is your friend....
WHERE (((tblSuppliers.LastWebUpdate)>=<cfqueryparam
cfsqltype="cf_sql_date" value="#variables.myDateVar#">))
Stephen
_______________________________________________
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 -<
