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]
