postgresql7.3 select status_id from pm_task_status where status_type = 'o' limit 1 select status_id from pm_task_status where status_type = 'c' limit 1 obviously broken select package_id from surveys where survey_id=:object_id select pm_task__new_task_item ( :project_id, :title, :description, :end_date, :percent_complete, :estimated_hours_work, :estimated_hours_work_min, :estimated_hours_work_max, :status_id, coalesce (:creation_date,current_timestamp), :creation_user, :creation_ip, :package_id)