[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