Yes... I set up an administration area for the client to manage the events -----Original Message----- From: Lawrence Ng [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 12:49 PM To: CF-Talk Subject: RE: OpenSource Calendar
thanks... do you have a site where we could acutally manage the events? the link you provided only displays the events. >>> [EMAIL PROTECTED] 12/3/2004 9:46:00 AM >>> I have it working here: http://www.londonderryeaston.com/calendar/calendar_public.cfm?fuseaction =ViewGoToMonth&GoToYear=2004&GoToMonth=11 -----Original Message----- From: Lawrence Ng [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 12:19 PM To: CF-Talk Subject: Re: OpenSource Calendar got an error trying to enter a test event ---------------- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'EndDate', table 'coldgen000130.dbo.Demo_ColdCalendar'; column does not allow nulls. INSERT fails. The error occurred in C:\domains\coldgen.com\wwwroot\coldcalendar\qry_processaddupdateevent.cf m: line 49 Called from C:\domains\coldgen.com\wwwroot\coldcalendar\index.cfm: line 31 Called from C:\domains\coldgen.com\wwwroot\coldcalendar\qry_processaddupdateevent.cf m: line 49 Called from C:\domains\coldgen.com\wwwroot\coldcalendar\index.cfm: line 31 47 : </cfquery> 48 : <cfelse> 49 : <cfinsert datasource="#Request.DataSourceName#" tablename="Demo_ColdCalendar" formfields="EventName, EventDesc, CreatedBy"> 50 : <cfset UpdateStartDate = #CreateDate(FORM.cboYearStart, FORM.cboMonthStart, FORM.cboDayStart)#> 51 : <cfset UpdateEndDate = #CreateDate(FORM.cboYearEnd, FORM.cboMonthEnd, FORM.cboDayEnd)#> Donations & Support: http://www.houseoffusion.com/tiny.cfm/54 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186125 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54