Friday, November 21, 2003, 11:47:14 AM, Bryan F. Hogan wrote:
> Most likely there is some sort of bug that was corrected in patch 3
> that effects your results. The different versions I very much doubt is
> the problem. Install patch 3 and see if your local copy looks like
> your remote copy.
Interesting. I did install Win2k SP3 on my local box and it did, in
fact, give me the same results as on the remotely hosted server.
What apparently was tripping me up was the <cfqueryparam> in the query.
I had:
<cfquery name="GetAppts" datasource="#request.dsn#">
SELECT ApptTime, ApptLength
FROM Reservations
WHERE EventID = #eventID#
AND ApptTime = <cfqueryparam value="#steptime#" cfsqltype="CF_SQL_TIMESTAMP">
</cfquery>
Changing the cfsqltype to "CF_SQL_TIME" fixed the problem and gave me
the correct results on both servers.
Thanks, Bryan, for guiding me through this.
--
Chris Montgomery
Airtight Web Services http://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-2415
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
