I found the problem. Stupid user error! I should have confirmed that my routine to check to see if the field is null was really returning the correct value...
- Dan >-----Original Message----- >From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] >Sent: Friday, July 22, 2005 11:35 AM >To: CF-Talk >Subject: MSSQL Contraint/Null Issue... > >I've got a problem I've never run into before. In the application I've >recently inherited they've defined a constraint between two columns. >However, in the table that references the primary key the column can >actually contain a null value. > >The problem I'm running into is if I try to insert the data w/a null value >I >get a constraint issue, if I leave the column out completely then no >constraint issue is passed. > >Example: >insert into > [user] >( name, departmentId ) > values >( 'dan', null) > >That throws an error, while this won't: > >insert into > [user] >( name ) > values >( 'dan' ) > >The problem is I'm trying to do some operations in bulk so sometimes the >departmentId will be there and sometimes it won't. > >Is there a way around this? > >Thanks, >Dan > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212584 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
