Its too late now. :-) > -----Original Message----- > From: Matt Horn [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 2:25 PM > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] update query > > > doh! > > true > > I retract > > > At 14:21 09/08/02 +0100, you wrote: > >not in an update ! only in an insert. > > > >J > > > > > -----Original Message----- > > > From: Matt Horn [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, August 09, 2002 2:19 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: [ cf-dev ] update query > > > > > > > > > if you dont specify that colunm it gets set to the default > > > > > > also > > > bits are 0 or 1 > > > > > > they cannot be NULL > > > > > > > > > At 14:08 09/08/02 +0100, you wrote: > > > >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]
