Query Falsly Returns Zero Records

i have access db on local machine - set dev web server running cf dev edition.

the exact same access db (i copied it) running on testing server using cf dev edition.

on local machine, query returns 3 records (correctly). testing server, query returns 0 records. how can exact same database return 2 different results when db's identical , query same?

here cfcode , shows in debugging section on browser.

would helpful if attached code
local machine

getevents (datasource=wcrcalendar, time=0ms, records=3) in c:\inetpub\calendar\index.cfm @ 13:51:31.031

<cfquery name="getevents" datasource="#db#">
select * tblcalendar
evt_date >= ###dateformat(startdate,'mm/dd/yyyy')### ,
evt_date <= ###dateformat(enddate,'mm/dd/yyyy')### ,
evt_approved = 1
order evt_date, evt_time
</cfquery>

select * tblcalendar
evt_date >= #07/01/2006# ,
evt_date <= #07/31/2006# ,
evt_approved = 1
order evt_date, evt_time


testing server

<cfquery name="getevents" datasource="#db#">
select * tblcalendar
evt_date >= ###dateformat(startdate,'mm/dd/yyyy')### ,
evt_date <= ###dateformat(enddate,'mm/dd/yyyy')### ,
evt_approved = 1
order evt_date, evt_time
</cfquery>

getevents (datasource=wcrcalendar, time=0ms, records=0) in d:\inetpub\wwwroot\tools\calendars\wcr\index.cfm @ 13:04:40.040
select * tblcalendar
evt_date >= #07/01/2006# ,
evt_date <= #07/31/2006# ,
evt_approved = 1
order evt_date, evt_time

More discussions in Database Access

adobe