MSSQL / ColdFusion problem

I keep on getting this annoying error! What am I doing wrong?


Error Executing Database Query.
[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\wwwroot\ab\source\dailysheet.cfm: line 124

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



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

SQL insert into TB_AmericanBeauties.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 (2996, Null, '05/08/2004', Null, Null, 'testing123', '', '1000', '1hr', 'elite', 'avis verge', Null, 'blondie', Null, Null, getdate(), '1' )
DATASOURCE AmericanBeauties
VENDORERRORCODE 2627
SQLSTATE 23000

Heeeeeeeelp!!!!!

This has nothing to do with ColdFusion. You are attempting to insert a duplicate primary key into a table. A primary key must be unique. The constraint that you are violating is 'PK_TB_DailySheet1'. Insert a different value for the key.

ok
it is very strange that it lets me actually input when it feels like it.
I should axe murder the guy who created this!