i have this kind of error when im trying to add in the database a sample event:
Error Executing Database Query.
General error: Out of range value adjusted for column 'type' at row 1
The error occurred in C:\CFusionMX7\wwwroot\examples\datetimeprompt.cfm: line 19
17 : VALUES('Sample event',
18 : #CreateODBCDateTime(CreateDateTime(FORM.year, FORM.month, FORM.day, FORM.hour, FORM.minute, 0))#,
19 : '#CreateUUID()#',
20 : 'Sample',
21 : 'public',
SQL INSERT INTO lcf_event (description, event_date_time, event_id, title, type, user_id) VALUES('Sample event', {ts '2004-01-01 00:00:00'}, 'B726827A-B6A5-618D-1ED21D6E197C8DCC', 'Sample', 'public', 'abcd')
DATASOURCE learningcoldfusion
VENDORERRORCODE 1264
SQLSTATE S1000
2006-11-04
19:09:27
·
1 answers
·
asked by
Mitko
3
in
Programming & Design