[thelist] Updating two fields with SQL

[Anthony Baratta]

At 09:15 AM 8/21/2000, you wrote:
>Dear evolta,
>I don't know if this is syntatically legal, but it should be logically
>correct. I'd like to update two fields of a row in one SQL statement.
>I've been using the following (without much success):
>    UPDATE TableName
>    SET    FirstField='New Value 1'
>    AND    SecondField='New Value 2'
>    WHERE  ID='#form.ID#'
>
>It hasn't worked both with and without the single quote marks for the
>ID, which is an autonumber in Access. Any thoughts? Thanks in advance.

Change the AND to a comma

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


----
Anthony Baratta
President
Keyboard Jockeys