I have an inconsistent problem that seems like it might be a bug. It's on a
Solaris server running netscape server thingy 4.0, oracle 8 something, and
CF Server 4.0 (in spite of other problems specifically fixed in 4.01 they
refuse to install it). I haven't been able to find any documentation
referring to it, but I understand that cfserver for solaris has some
undocumented problems (we have several confirmed undocumented issues) which
are supposed to be fixed in 4.5 for solaris (which the client insists will
come out today). The client won't pay us until this problem is fixed, but
our attempts to fix it have had weird and unsuccessful results. I have
explained that it seems to be a software issue and they need to upgrade the
server, but they still won't upgrade. They insist that I should program
around the bug and we're not willing to do that. I am trying to avoid
paying Allaire to tell me that I have an undocumented bug, so if anyone can
get me some information, I would really appreciate it.
Here's our problem:
We have an event calendar that is supposed to pull records depending on
what time of day it is. The records are pulled for each day
(EventStartDate) until the event ends (EventEndTime). The calendar works
sometimes and doesn't work other times. The time of day is set correctly
enough on the server to not cause this problem.
This usually works in the morning and early afternoon.
<cfquery name="GetTodaysEvents" datasource="#application.CalendarDsn#">
SELECT EventID,
EventName,
EventDescription,
EventStartTime,
EventEndTime,
TO_CHAR(Trunc(EventStartDate), 'DD-Mon-YY') As
EventStartTimeFormatted,
EventEndDate
FROM tblEvents
WHERE TO_CHAR(Trunc(EventStartDate), 'DD-Mon-YY') = '27-Mar-00'
and TO_CHAR(EventEndTime, 'HH:MI AM') > '#TimeFormat(DateToday, "hh:mm tt")#'
AND exhibition !=1
ORDER BY EventStartTimeFormatted;
</cfquery>
This usually works in the late afternoon and evening.
<cfquery name="GetTodaysEvents" datasource="#application.CalendarDsn#">
SELECT EventID,
EventName,
EventDescription,
EventStartTime,
EventEndTime,
TO_CHAR(Trunc(EventStartDate), 'DD-Mon-YY') As
EventStartTimeFormatted,
EventEndDate
FROM tblEvents
WHERE TO_CHAR(Trunc(EventStartDate), 'DD-Mon-YY') = '27-Mar-00'
and TO_CHAR(Trunc(EventEndTime), 'HH:MI AM') > '#TimeFormat(DateToday,
"hh:mm tt")#'
AND exhibition !=1
ORDER BY EventStartTimeFormatted;
</cfquery>
To illustrate the problem, I have set up the following page:
http://grey.tcs.tulane.edu/TulaneSiteTesting/jentest1.cfm
It contains 6 variations on the intended query, all labelled so you can
tell them apart. Frankly, I don't know why the dates in the time field are
all set to the first of whatever month the event is in, but that doesn't
seem to be the problem. I'm sure I could figure that out if I thought it
would make a difference ( I didn't set up the function that sets up the
dates and times). I'll be happy to send anyone the testing code, but the
two queries above are "EventEndTime more than
<cfoutput>#Now()#</cfoutput><br>Not truncated time only in query" and
"EventEndTime more than <cfoutput>#Now()#</cfoutput><br>Truncated time only
in query"
Here is the cfoutput code for all of the queries:
Event ID: #eventid#<br>
Event Name: #EVENTNAME#<br>
Event Start Time: #EventStartTime#<br>
Event End Time: #eventendtime#<br>
Event Start Time Formatted: #eventstarttimeformatted#<br>
Event End Date: #eventenddate#
Thanks for taking the time out to look at the weirdness.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
