SQL Update syntax

[chemosabe]

SQL Update syntax [RESOLVED]

Hi

Im trying to update a table that has two key fields; ive tried

UPDATE tbl
SET [val_1]=1,...[val_n]='str'
WHERE [key_1]=1,[key_2]=2;

But this gives me an error on the WHERE clause. What is the correct syntax?

Thanks.

 

[Kiwiman]

Howzit

try

WHERE [key_1]=1 AND [key_2]=2;

 

[chemosabe]

Duh...

Thanks, that solved it