>- see footer for list info -<
Just to elaborate(first time I've ever used that word! :OD), if you do
have
#10/15/2005# in your code, it'll be evaluated as 10 divided by 15 divided
by
2005. Which is probably not illegal in SQL as dates can be numbers (the
number of milliseconds since the birth of Christ or something) so no
error
is thrown.
Adrian
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Marcos Placona
Sent: 23 March 2006 10:56
To: Coldfusion Development
Subject: Re: [CF-Dev] Date criteria ColdFusion/Access
- see footer for list info -<
Why are you surriounding the date with ##
In ColdFusion, this means variables, and maybe this is the problem, why
not
try like this:
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)>=#createODBCDate('10/15/2005')#))
ORDER BY tblSuppliers.SupplierName;
I'm using createodbcdate to pass a valid database date.
Test it and say what happened.
Cheers
----- Original Message -----
From: "Roger Broadhurst" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, March 23, 2006 10:51 AM
Subject: [CF-Dev] Date criteria ColdFusion/Access
>- 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 -<
_______________________________________________
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 -<
_______________________________________________
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 -<
