i have problem with my coldfusion/mysql code! Can someone help me please?

Question

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

yes but what is the problem, thats what im asking i know i have a problem in line 19 but i cant find it and im learning coldfusion later i will learn php also :)

i found where is the mistake:


This is a wide spread problem in New MySQL 5.0 installs. I solved it by opening the file 'my.ini' in your MySQL install folder - the config file. And commenting out the command near the top that turns on the 'strict' mode.
-gl

Answer 1

u have problem with line 19....check it....better use php with mysql