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)#> SQL insert into Demo_ColdCalendar (EventName,EventDesc,CreatedBy) values ( (param 1) , (param 2) , (param 3) ) DATASOURCE coldgen VENDORERRORCODE 515 SQLSTATE HY000 Please try the following: Stack Trace at cfqry_processaddupdateevent2ecfm1487833730.runPage(C:\domains\coldgen.co m\wwwroot\coldcalendar\qry_processaddupdateevent.cfm:49) at cfindex2ecfm248875144.runPage(C:\domains\coldgen.com\wwwroot\coldcalenda r\index.cfm:31) at cfqry_processaddupdateevent2ecfm1487833730.runPage(C:\domains\coldgen.co m\wwwroot\coldcalendar\qry_processaddupdateevent.cfm:49) at cfindex2ecfm248875144.runPage(C:\domains\coldgen.com\wwwroot\coldcalenda r\index.cfm:31) java.sql.SQLException: [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. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186120 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
