Thanks guys I think I figured it out with your help.
The problem is the time thing. I eliminated the time portion and just
inserted the date without any time and it works perfectly....
Jeff
----- Original Message -----
From: "Jeff - Development" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 04, 2003 4:38 AM
Subject: Help with ACCESS and DATES.. Oh The Horror!!
> I've got a strange one, its pretty strange to me, maybe not to one of
you...
>
> I insert a date for a record using this set statement....
> <cfset form.record_modifieddate=createodbcdate(now())>
>
> and inside the database the record looks like this
>
> 8/1/2003 2:47:29 AM
>
> There are about 12 entries on this particular date, various times. Easy
> enough. Now I go to query based on a particular date:
>
> --------
> <cfset today = Createodbcdatetime("8/1/2003")>
>
> <cfquery name="q_todaytotal" datasource="contacts.mdb">
>
> SELECT *
> FROM contacts
> WHERE record_modifieddate = #today#
> </cfquery>
> <cfset total_calls = #q_todaytotal.recordcount#>
> <cfoutput>#total_calls#</cfoutput> Total Calls. <br>
> ---------
> I get 0 for results when I should be getting 12. This query doesn't work
> when I use createodbcdate instead of createodbcdatetime. I still get 0.
>
> Heres the weird part... When I query a SPECIFIC time...
>
> ---------
> <cfset today = Createodbcdatetime("8/1/2003 2:47:29")>
>
> <cfquery name="q_todaytotal" datasource="contacts.mdb">
>
> SELECT *
> FROM contacts
> WHERE record_modifieddate = #today#
> </cfquery>
> <cfset total_calls = #q_todaytotal.recordcount#>
> <cfoutput>#total_calls#</cfoutput> Total Calls. <br>
> ----------
>
> I get a result of 1. How the heck do I query for an entire day, getting
all
> 12 records on that date???? There has to be something REAL simple thats
> wrong with my date query..
>
> Thanks..
> Jeff
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
