<div>
With insert/update query you can add result attribute to check number of rescords being updated.<br />
To avoid duplicates, you may check the existence of record matching the pk or fk.<br />
<br />
If record exists, may be you want to run update query.<br />
<br />
for example<br />
<br />
&lt;cfquery datasource=&quot;#request.dsn#&quot;<wbr /> name=&quot;saveChanges&quot; result=&quot;updateResult&quot;&gt;<br />
UPDATE table_name<br />
SET <br />
column1 = '#value1#', <br />
column2 = '#value2#'<br />
WHERE column3 = 1<br />
&lt;/cfquery&gt;<br />
<br />
&lt;cfset recordsChanged = updateResult.recordCount&gt;
</div>


With insert/update query you can add result attribute to check number of rescords being updated.
To avoid duplicates, you may check the existence of record matching the pk or fk.

If record exists, may be you want to run update query.

for example

<cfquery datasource="#request.dsn#" name="saveChanges" result="updateResult">
UPDATE table_name
SET
column1 = '#value1#',
column2 = '#value2#'
WHERE column3 = 1
</cfquery>

<cfset recordsChanged = updateResult.recordCount>

<div>
<div class="content wysiwyg-content">
I have a bunch of queries which insert data into my SQL server and sometimes I get a duplicate record which <br />
throws an error like this<br />
<br />
Error Executing Database Query.[Macromedia][SQLServ<wbr />er JDBC Driver][SQLServer]Violatio<wbr />n of PRIMARY KEY constraint 'PK_tbl_CNR_D'. Cannot insert duplicate key in object 'dbo.tbl_CNR_D'. The duplicate key value is (C2491035056, 01, 1428310095, ). The specific sequence of files included or processed is: C:\inetpub\wwwroot\parse.c<wbr />fm, line: 452 <br />
<br />
how can I capture this in my code and act accordingly ?<br />
<br />
I want to avoid to have to fire of a query to see if recordcount GT 0 to avoid this
</div>
</div>


I have a bunch of queries which insert data into my SQL server and sometimes I get a duplicate record which 
throws an error like this

Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_tbl_CNR_D'. Cannot insert duplicate key in object 'dbo.tbl_CNR_D'. The duplicate key value is (C2491035056, 01, 1428310095, ). The specific sequence of files included or processed is: C:\inetpub\wwwroot\parse.cfm, line: 452 

how can I capture this in my code and act accordingly ?

I want to avoid to have to fire of a query to see if recordcount GT 0 to avoid this

whow to capture SQL errors in Coldfusion

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.