Ryan
On 7/11/06, Sona Solanki
<[EMAIL PROTECTED]> wrote:
you need quotes around the pound signs.On 7/10/06, Ray Hughes < [EMAIL PROTECTED]> wrote: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/
_______________________________________________
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/
