CF 4.0, Oracle 73.3.4
I have an insert statement within a CFLOOP tag:
<CFQUERY name="INSERT" datasource="D"
INSERT INTO Table (SSN)
Some records might already be in the table and the loop stops after the dup row is rejected (error: [Oracle][ODBC][Ora]ORA-00001: unique constraint (P.PK_TABLE) violated).
How can I get the loop to go to the next record and continue processing? I am thinking in terms of the On Error Resume Next feature of VBA.
Thanks in advance for your time and help.