Updating multiple fields in a form

[lesleye]

I would like to display the values in my database, and then have the user Update more than one field in the form. The update command only allows to update a specific field. Is there a way to update multiple fields in the form?

Thanks: Lesley

 

[JarlH]

What database system are you using, what form? This is the ANSI SQL forum, perhaps you should try a vendor specific forum instead.

 

[lesleye]

I am using mySQL.

 

[r937]

update mytable
set myfield1 = value1
, myfield2 = 'value2'
, myfield3 = null
, myfield4 = etc
where mypkey = keyvalue

rudy

http://r937.com/

SQL Consulting