Anaother bug in SQL

[berttb]

When updating a task with the following SQL syntax:

UPDATE `tasks` SET task_name='Start project',task_parent='1',task_milestone='1',task_p roject='1',task_owner='2',task_start_date='2006-06-15 17:00:00',task_duration='1',task_duration_type='24 ',task_hours_worked='0',task_end_date='20060616170 000',task_status='0',task_priority='0',task_percen t_complete='65',task_target_budget='0.00',task_rel ated_url='',task_creator='2',task_order='0',task_c lient_publish='0',task_dynamic='',task_access='0', task_notify='1',task_type='0' WHERE task_id='1'

I got an errormessage from dotProject.

In EMS I got the next message: Incorrect integer value: '' for column 'task_dynamic' at row 1, because this item was not filled in by the code.

[Deacon]

"parent='1',task_milestone='1',task_p roject='1',task_owner='2',task_start"

In the first row, check the broken string task_p roject='1'. Not sure if that's what's causing it because it could be your copy/paste, but check it.

Deacon