records make no sense...
<shot in the dark>
have you tried to rename it, something very off the wall, just
to make sure its not the same name as another access db on the same
server?
</shot in the dark>
....tony
Tony Weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
410.548.2337
www.navtrak.net
-----Original Message-----
From: Amy Wilder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 11:48 PM
To: CF-Talk
Subject: Different cfquery results - local vs. hosted
Hi,
I'm fairly new to CF and I'm developing my first CF site that uses a web
hosting package for the database/datasource. When I developed my site
and tested it locally using my copy of the Access database, it worked
fine. But when I ftp the Access database and my pages to the host and
go through the app remotely, I get different results for my queries.
Help meeee....
Some searches work fine so I know it's connecting to the datasource.
But some searches come up with zero records when I know the records are
out there... could it be a timeout issue? (unlikely given the small
number of records and the quick response times I'm getting). Any other
ideas of where to even begin? I don't know that my host would/could
turn on debugging, though I might pursue that in the morning. But if
the SQL query is okay but the results are not, where to begin???
Any and all help is greatly appreciated.
-Amy Wilder
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
