Hi Ryan,
This query with # signs
SELECT Q01, Q02, Q03
FROM Cars
WHERE dateCreated BETWEEN #2006-01-05# AND #2006-01-11#
Returns no records.
Thanks
Regrads
From: "Ryan Everhart" <[EMAIL PROTECTED]>
Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing
List<[email protected]>
To: "Dallas/Fort Worth ColdFusion User Group Mailing
List"<[email protected]>
Subject: Re: [DFW CFUG] Trouble Obtaining a date range from an ACCESS
database
Date: Mon, 10 Jul 2006 14:41:00 -0500
Ray,
I just tried some stuff and this is what I came up with... try adding, if
you can, pound signs and remove the single ticks. I'm not sure why, but
some how this tells access that it is a date.
WHERE dateCreated BETWEEN #2006-01-05# AND #2006-01-11#
Note I tired this in Access stand alone, not through ColdFusion to Access.
Ryan
On 7/10/06, Ray Hughes <[EMAIL PROTECTED]> wrote:
Hi All,
Thanks everyone I am still searching.
Regards
This query:
SELECT dateCreated
FROM cars
WHERE dateCreated BETWEEN '2006-01-05' AND '2006-01-11'
Returns an error
Error: Data type mismatch in criteria expression. (State:22005, Native
Code:
FFFFF42A)
This query:
SELECT dateCreated
FROM cars
WHERE dateCreated BETWEEN {d '2006-01-05'} AND {d '2006-01-11'}
Returns ZERO Records
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
--
Ryan Everhart
[EMAIL PROTECTED]
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
