sql insert help

[jroscoe]

I get the error ORA-00917: missing comma with the following sql:

INSERT into SYSADM.INSUR_SURVEY (SURVEY_NME, BEGIN_DTE = to_date('03/01/2003', 'mm/dd/yyyy'), END_DTE = to_date('03/31/2003', 'mm/dd/yyyy'), EMAIL_ID = '[e-mail]', HTML_TXT = '') values (:survey_nme, :begin_dte, :end_dte, :email_id, :body)

Can someone help here?

Thanks

[Kudose]

mysql_query = "INSERT INTO sysadm.insur_survey ((SURVEY_NME, BEGIN_DTE = to_date('03/01/2003', 'mm/dd/yyyy') (END_DTE = to_date('03/31/2003', 'mm/dd/yyyy'), (EMAIL_ID = '[e-mail]', HTML_TXT = '')) VALUES ($survey_nme, $begin_dte, $end_dte, $email_id, $body)";

Try that and lemme know what it says...