This constraint in the PlumTutorials DDL: CONSTRAINT CK_InventoryItem_Status CHECK (Status IN (0,10,20))
prevents anything other than zero, 10, or 20 from being stored in the Status column, so it's rejecting your values. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ----- Original Message ----- From: "Dan" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, April 12, 2005 9:10 PM Subject: [plum] I broke it. I'm sorry > Okay, I figured it out-how I broke my plum. > > > > A step or two back in the Tutorial when I enumerated the status list, I > entered 0 for inactive, 1 for active, and 2 for special order. > > > > If I now try to Add an Item and select Active or Special Order, I get the > .invalid data. error message. > > But if I select Inactive it goes in just fine. Because 0 = inactive is a > valid attribute+value pair (I'm guessing) > > > > I'll go back and "fix" my enumerated status codes and I bet my plum will be > good enough to eat-again. > > > > > > > > > > Dan Kaufman > > > > > > > > An Elephant Never Forgets > > [EMAIL PROTECTED] > > > > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
