ignore last post then... ----- Original Message ----- From: "Russ 'Snake' Michaels" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 3:13 PM Subject: RE: [ cf-dev ] update query
> actually it is cf doing this, because queries run directly against SQL > server do not do this. > > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > Sent: 09 August 2002 15:07 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] update query > > > it was off in the first place. > I also defaulted it to 1, no difference. it happens with any BIT field I add > to the table. they all get reset to 0 if I do not specify a value. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: 09 August 2002 15:09 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] update query > > > > i don't know why that would be happening, but try turning off the default > setting. > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > "Russ 'Snake' > Michaels" To: > <[EMAIL PROTECTED]> > <snake@snakep cc: > it.net> Subject: RE: [ cf-dev ] update > query > > 08/09/02 > 03:02 PM > Please > respond to > dev > > > > > > Amazing, i deleted the column, added a new one with a new name, and this > also gets set to zero with every update as well. > > -----Original Message----- > From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] > Sent: 09 August 2002 14:58 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] update query > > > Sounds like a "Friday" bug, the solution; 2 days drinking, eating and > having > fun.. > > Justin > > > -----Original Message----- > > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 09, 2002 2:49 PM > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] update query > > > > > > sql server 2000 > > it's actually called AdminAdded, and does not show as reserved > > > > > > > > -----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] > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
