Cannot insert the value NULL

[phreakgrrrl]

Having issues with my shopping cart.
this is the error and the page it's on:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'basketitemID', table 'paceprintscatalog.dbo.basket'; column does not allow nulls. INSERT fails.

http://www.paceprints.com/secure/addtoshoppingcart.asp

When i look into the tables it says the value does allow nulls so i'm at a loss.. any help would be great... thank you!

 

[gmmastros]

Do you have a trigger on this table that is trying to insert values in to another table that does not allow nulls?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

Theb table is 'paceprintscatalog.dbo.basket' and the column is 'basketitemID'
Are you sure that you looked at the correct table
run this
SELECT COLUMNPROPERTY( OBJECT_ID('basket'),'basketitemID','AllowsNull')

if it returns 0 then the column does NOT allow nulls

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/