SQL UPDATE statement with SET

[shadowspell]

Is it possible to SET two or more field values with one UPDATE statement, such as the following. The syntax will be incorrect...

SQLstmt = "UPDATE tbl_wr_Main SET dev_proj_status = 'Assigned' dev_developer = 'Johnson' WHERE tbl_wr_Main.id IN (" & dev_accept_these & ")"

The variable dev_accept_these contains checkboxes values.
Although the syntax is incorrect (assuming this can be done) can what I want to accomplish be done with one UPDATE statement?
Thanks for any help,
Chris

 

[PHV]

Have you tried this ?
SQLstmt = "UPDATE tbl_wr_Main SET dev_proj_status = 'Assigned'[highlight],[/highlight] dev_developer = 'Johnson' WHERE tbl_wr_Main.id IN (" & dev_accept_these & ")"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[shadowspell]

Thanks PHV,

That was it- one stupid little comma.



Chris