Were the classes that you are having a problem with created before daylight saving 
began, or is this a problem even with new events?  Depending on how your specific DB 
stores dates, you may need to make an adjustment.

Kevin


>>> [EMAIL PROTECTED] 05/08/01 04:35AM >>>
Kevin, Thank You.
no i am not using the GetTimeZoneInfo function.
i didn't know there was one, should i be using it?
how would i use it?
i was just pulling the date from the db, which was inserted at class
creation.

Jim, thanks. but i think that may be unrelated.
the article says it would only affect the server the first week of daylight
savings time.

<!--- code of form that sends to the action page --->

<form action="ThankYou2.cfm/events.vcs" method="post">
<INPUT TYPE="hidden" NAME="CalendarID"
VALUE="<CFOUTPUT>#FORM.CalendarID#</CFOUTPUT>">
<input type="submit" value="Add to My Outlook Calendar">        
</form>

<!--- code of action page --->

<!--- ---------------- Add To MS CAlenddar ------------- --->
<cfquery name="OutlookAdd" datasource="edu">
SELECT *
FROM tbl_Calendar, tbl_Class, tbl_Program, tbl_Room
WHERE tbl_Calendar.CalendarID  = #FORM.CalendarID# 
AND tbl_Class.ClassID = tbl_Calendar.ClassID 
AND tbl_Room.RoomID = tbl_Calendar.RoomID
</cfquery>

<!--- <CFSET Min_One_Hour = OutlookAdd.Calendar_Time - 1> --->

<!--- vcalendar --->
<CFCONTENT type="unknown">
        <CF_VCALENDAR
        startdate = "#dateformat(OutlookAdd.Calendar_Date,"mm/dd/yyyy")#"
        starttime="#timeformat(OutlookAdd.Calendar_Time,"HH:mm")#"
        durationhours="#OutlookAdd.Calendar_Duration#"
        title="#OutlookAdd.ClassTitle#"
        
description="http://inhouse/default.cfm?mainpage=education/Class_View.cfm?Cl 
assID=#OutlookAdd.ClassID#"
        location="#OutlookAdd.RoomName#"
        uid="#OutlookAdd.ClassTitle# - #OutlookAdd.CalendarID#">
        CATEGORIES:MEETING

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED] 
        614 241-3534
fax:    614 485-5534

Home:   [EMAIL PROTECTED] 
        614 449-1681

> icq:  47658358
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to