Hey guys! thanks a bunch that really fixed my problem. Thanks for your
prompt response.
cybm
On 3/20/06, Johan Höök <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I think your problem is that OR and AND do not
> have the same precedence, AND binds tighter.
> So what you need is probably:
> (products_mode
"cybermalandro cybermalandro" <[EMAIL PROTECTED]> wrote on
03/20/2006 11:00:51 AM:
> I am trying to update a table with a file that has more than one update
> statements like this:
>
>
> UPDATE products set products_price="22.00" WHERE
products_model="5217-01"
> OR products_model="521701" AND
Hi,
I think your problem is that OR and AND do not
have the same precedence, AND binds tighter.
So what you need is probably:
(products_model="5217-01" OR products_model="5217-01") AND
products_um="CS" and the same for "PK" and "EA".
The way you have you'll get an update as soon as
products_mode
I am trying to update a table with a file that has more than one update
statements like this:
UPDATE products set products_price="22.00" WHERE products_model="5217-01"
OR products_model="521701" AND products_um="CS";
UPDATE products set products_price="3" WHERE products_model="5217-01" OR
produ
