[thelist] Updating two fields with SQL

[Scott Dexter]

>    UPDATE TableName
>    SET    FirstField='New Value 1'
>    AND    SecondField='New Value 2'
>    WHERE  ID='#form.ID#'
> 

replace the AND with a comma:

Update <table> Set Field1=value, Field2=value, Field3=value ... WHERE
<clause>

sgd