Coldfusion and MSSQL enter error

[rninja]

I keep getting this message. I am not a coldfusion programmer so I would need someone to walk me through a bit. I understand obvious or some of the programming, but I want to fix this and it always happens on this one page...

[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_TB_DailySheet1'. Cannot insert duplicate key in object 'TB_DailySheet'.

The Error Occurred in C:\CFusionMX\

http://wwwroot\company\source\dailysheet.cfm:

line 124

122 : </cfif>
123 : )
124 : </cfquery>
125 : <cfset dstime = "">
126 : <cfset ds_cname = "">



--------------------------------------------------------------------------------

SQL insert into TB_COMPANY.dbo.TB_DailySheet (ds_id, ds_day, ds_dt, ds_lo, ds_time, ds_cl_name, ds_source, ds_to_fee, ds_duration,ds_cate, ds_rp_name, ds_rp_fee, ds_tp_name, ds_tp_fee, ds_hs_fee, cr_dt, cr_by) values (2521, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, Null, getdate(), '1' )
DATASOURCE COMPANY
VENDORERRORCODE 2627
SQLSTATE 23000

Does anyone know why this could be?

I really appreciate help with this one..

Rninja

http://www.rninja.com

 

[NetworkGuy101]

Looks like it is probably the settings for the primary id field for TB_DailySheet what type of field is it