| 
 Posted by Phil Latio on 05/23/07 05:18 
I am inserting data into user table which contains 5 fields, sounds simple  
enough normally but 2 of the fields are designated as UNIQUE. If someone  
does enter a value which already exists, how do I capture this specific  
error? 
 
Would it make more sense to actually run a SELECT query first and if that  
returned a result, then I use that for error checking and don't run insert  
until select returns nothing? 
 
Cheers 
 
Phil
 
  
Navigation:
[Reply to this message] 
 |