Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating logic based on an Oracle error

Status
Not open for further replies.
iao

iao

Programmer
Feb 23, 2001
111
US
I have a form where the user enters values directly into a database. One of the values they can select from is the primary key value in the database.

If the user tries to enter this value more than once, an error is returned with "ORACLE ERROR CODE = 1 (unique constraint violated)".

Is there a way in CF to write some kind of logic so that if this error occurs, skip this instance of the insert and continue on to the next record?
 
Status
Not open for further replies.

Similar threads

fdgsogc
  • Locked
  • Question
Displaying results of an SQL Pivot Query
Replies
1
Views
625
jdhilljr
jdhilljr
HansKok
  • Locked
  • Question
Error after only changing text and not codes
Replies
0
Views
559
HansKok
HansKok
FALCONSEYE
  • Locked
  • Question
Error: no known VMs. (check for corrupt jvm.cfg file) !!! How I Fixed It !!!
Replies
0
Views
791
FALCONSEYE
FALCONSEYE
cfuser10
  • Locked
  • Question
Populating Text Box based on CFSelect Value
Replies
2
Views
270
cfuser10
cfuser10
hifispin2015
  • Locked
  • Question
Creating a slect all button for A Multiple Slect HTML Form Field
Replies
1
Views
277
LyndonOHRC
LyndonOHRC

Part and Inventory Search

Sponsor

Back
Top