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.cfm:
line 49
Called from C:\domains\coldgen.com\wwwroot\coldcalendar\index.cfm: line
31
Called from
C:\domains\coldgen.com\wwwroot\coldcalendar\qry_processaddupdateevent.cfm:
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.com\wwwroot\coldcalendar\qry_processaddupdateevent.cfm:49)
at
cfindex2ecfm248875144.runPage(C:\domains\coldgen.com\wwwroot\coldcalendar\index.cfm:31)
at
cfqry_processaddupdateevent2ecfm1487833730.runPage(C:\domains\coldgen.com\wwwroot\coldcalendar\qry_processaddupdateevent.cfm:49)
at
cfindex2ecfm248875144.runPage(C:\domains\coldgen.com\wwwroot\coldcalendar\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:186111
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
