trouble with insert in data

[J.BIRD]

I have the following insert statement, there are 30 columns, and 30 input values and commas between each and I am getting an oracle error of "missing comma"

INSERT INTO agent_med_exam
(exam_id,
exam1_nurse,
exam1_schedule,
exam1_time,
exam1_loc,
exam1_comp,
exam2_nurse,
exam2_schedule,
exam2_time,
exam2_loc,
exam2_comp,
extra_exam_req,
med_info_ret,
further_info_req,
aig_notified,
light_duty,
light_duty_txt,
ret_full_duty,
failure_date,
failure_reason,
failure_sent,
next_exam_due,
note1,
note2,
lastmod_by,
lastmod_on,
exam_status,
letter_date,
letter_type,
emp_id
)
VALUES ( '#count#',
'#getData.exam1_nurse#',
<cfif getData.exam1_schedule IS 'NULL' >01/10/1900<CFELSE>#getData.exam1_schedule#</cfif>,
'#getData.exam1_time#',
'#getData.exam1_loc#',
<cfif getData.exam1_comp IS 'NULL' >01/10/1900<CFELSE>#getData.exam1_comp#</cfif>,
'#getData.exam2_nurse#',
<cfif getData.exam2_schedule IS 'NULL' >01/10/1900<CFELSE>#getData.exam2_schedule#</cfif>,
'#getData.exam2_time#',
'#getData.exam2_loc#',
<cfif getData.exam2_comp IS 'NULL' >01/10/1900<CFELSE>#getData.exam2_comp#</cfif>,
<cfif getData.extra_exam_req IS 'NULL' >01/10/1900<CFELSE>#getData.extra_exam_req#</cfif>,
<cfif getData.med_info_ret IS 'NULL' >01/10/1900<CFELSE>#getData.med_info_ret#</cfif>,
<cfif getData.further_info_req IS 'NULL' >01/10/1900<CFELSE>#getData.further_info_req#</cfif>,
<cfif getData.aig_notified IS 'NULL' >01/10/1900<CFELSE>#getData.aig_notified#</cfif>,
<cfif getData.light_duty IS 'NULL' >01/10/1900<CFELSE>#getData.light_duty#</cfif>,
'#getData.light_duty_txt#',
<cfif getData.ret_full_duty IS 'NULL' >01/10/1900<CFELSE>#getData.ret_full_duty#</cfif>,
<cfif getData.failure_date IS 'NULL' >01/10/1900<CFELSE>#getData.failure_date#</cfif>,
'#getData.failure_reason#',
<cfif getData.failure_sent IS 'NULL' >01/10/1900<CFELSE>#getData.failure_sent#</cfif>,
<cfif getData.next_exam_due IS 'NULL' >01/10/1900<CFELSE>#getData.next_exam_due#</cfif>,
'#getData.note1#',
'#getData.note2#',
'#getData.lastmod_by#',
<cfif getData.lastmod_on IS 'NULL' >01/10/1900<CFELSE>#getData.lastmod_on#</cfif>,
'1',
#getData.congrat_sent#,
'Congrats',
'#id#'
)


and it is throwing this error

ORA-00917: missing comma

The error occurred in C:\CFusionMX7\wwwroot\AgentMed\test1.cfm: line 95

93 : #getData.congrat_sent#,
94 : 'Congrats',
95 : '#id#'



front end is cold fusion and back end is oracle 10g.


Anyone have an Idea of whats causing this?

[skhanal]

Check if you have any double quotes on the values part. Also see if all single quotes are matched.

[skhanal]

I think you need to include values like these in single quotes

<cfif getData.lastmod_on IS 'NULL' >01/10/1900<CFELSE>#getData.lastmod_on#</cfif>,