Well I never, quite a few Qs on here tonight (my own *bold* one and now Eric's *Killing....*) seem to be the victim of some dastardly plot - if you can understand this, you are doing well !
Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'Answer', table '@tAnswers'; column does not allow nulls. INSERT fails. /Toolkit/answ.asp, line 599
The only script I understand are the ones I'm given and told to learn lines from. Jibberish makes more sense to me than the stuff on here...And I have no idea why next doors cats are being dragged in to it either.
juggerling - if you get time, pop and have a look at the thread titled Now here's a very good answer
It's quite revealing
'80040e2f'
<%
' ...
conn.execute("DELETE table WHERE column ...")
%>
Microsoft OLE DB Provider for ODBC Drivers error '80040e2f'
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'PK_<tablename>'. Cannot insert duplicate key in
object '<tablename>'.
DELETE statement conflicted with COLUMN REFERENCE constraint 'tblGuestName_FK00'. The conflict occurred in database 'news', table 'tblGuestName', column 'Thread_ID'.
/news/forum/admin/delete_category.asp, line 111
/var/www/aps/xaraya-core-monotone/core-stable/html/includes/xarSession.php [153]
: !is_null($value); /* Not allowed to set variable to NULL value */