[thelist] Updating two fields with SQL

Minh Lee Goon v7ac at sdsumus.sdstate.edu
Mon Aug 21 11:14:26 CDT 2000


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.

</ml>





More information about the thelist mailing list