Think you had to use "#" pound
symbols instead of single ticks... just a flag in memory for some
reason.
Thanks
___________________________________________________
Galen M. Smallen
Sr. IT Systems Analyst
Quality Data Systems
Bell Helicopter - Textron
Sr. IT Systems Analyst
Quality Data Systems
Bell Helicopter - Textron
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Shuck
Sent: Monday, July 10, 2006 1:28 PM
To: Dallas/Fort Worth ColdFusion User Group Mailing List
Subject: Re: [DFW CFUG] Trouble Obtaining a date range from an ACCESS database
SELECT dateCreated
FROM cars
WHERE dateCreated BETWEEN '2006-01-09' AND '2006-01-11'
~Dave
On 7/10/06, Ray
Hughes <[EMAIL PROTECTED]> wrote:
Hi All,
I am having a problem acquiring a date selection range from an access
database.
When I use the following query on an SQl database it works fine.
SELECT dateCreated
FROM cars
WHERE dateCreated > '2006-01-09'
anD dateCreated < '2006-01-11'
If I use the above query on an access database I receive
"Error: Data type mismatch in criteria _expression_. (State:22005, Native
Code: FFFFF42A)"
When I use the following query with no Tick marks. I obtain zero records.
SELECT dateCreated
FROM cars
WHERE dateCreated > 2006-01-09
anD dateCreated < 2006-01-11
When I use the following query I receive 60 records.
SELECT dateCreated
FROM cars
I have 60 records entered for january. At least two records for each day.
I have verified that the data exists for these days.
The dateCreated is of datatype DATETIME.
I really could use some help.
Regards
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/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/
--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com
www.worldwildweb.biz
_______________________________________________ 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/
