sql server 2000 it's actually called AdminAdded, and does not show as reserved
-----Original Message----- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 09 August 2002 14:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] update query Weird. What Database you using? I did a test table with an admin column in MSsqlServer7 and it worked fine Any chance "admin" is reserved word in that DB? Justin --------------- test table sql ------------------------------------- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[test] GO CREATE TABLE [dbo].[test] ( [testid] [int] IDENTITY (1, 1) NOT NULL , [teststr] [varchar] (50) NULL , [admin] [bit] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[test] WITH NOCHECK ADD CONSTRAINT [DF_test_admin] DEFAULT (0) FOR [admin], CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED ( [testid] ) ON [PRIMARY] GO --------------- test table sql ------------------------------------- > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 2:30 PM > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] update query > > > UPDATE Companies > SET > Name='#FORM.Required_CompanyName#', > Address='#FORM.Address#', > Town='#FORM.Town#', > County='#FORM.County#', > Postcode='#FORM.Postcode#', > Country='#FORM.Country#', > > CompanyTelephone='#FORM.ReqPhone_CompanyTelephone#', > Fax='#FORM.NoRPhone_Fax#', > > CompanyEmail='#FORM.NoREmail_CompanyEmail#', > Website='#FORM.Website#', > > ContactPerson='#FORM.Required_ContactPerson#', > > ContactEmail='#LCase(FORM.ReqEmail_ContactEmail)#', > > ContactTelephone='#FORM.ContactTelephone#', > Brands='#FORM.Brands#', > ProductTypes='#FORM.ProductTypes#', > > MinimumOrder=#FORM.NoRNumer_MinimumOrder#, > > AvailableFrom='#FORM.AvailableFrom#', > > CourseSubjects='#FORM.CourseSubjects#', > > Qualifications='#FORM.Qualifications#', > CourseType='#FORM.CourseType#', > Services='#FORM.Services#', > ServiceType='#FORM.ServiceType#', > > PersonnelType='#FORM.PersonnelType#', > Employers='#FORM.Employers#', > AdType=#AdType#, > Active=#Status# > WHERE CompanyID=#FORM.ID# > > -----Original Message----- > From: Spike [mailto:[EMAIL PROTECTED]] > Sent: 09 August 2002 14:14 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] update query > > > What does your query look like? > > > -----Original Message----- > > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > > Sent: 09 August 2002 15:09 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] update query > > > > > > ok check this out. > > > > I have a field in the table > > > > Admin bit default(0) > > > > The value of this field is currently set to 1 > > I have just changed it to a NOT NULL value with a default, > > previous is a NULL, still did the same thing. > > > > I run an update query, this query DOES NOT update this > > column. There are no other update queries. Nothing touches > > this column at all. Yet every time I run an update query, > > this field gets set to 0 all by itself. there are no triggers > > or anything of this sort to cause it, it is just a plain old table. > > > > > > > > -- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
