Multiple Data Update

twin

Hi,

I want to update multiple row data on single click
Here is my code to update one row
sql="Update jobs SET instructions='"&instructions&"',date='"&date&" where job='"&job&"'"

Please help

Regards
Twin

shweta123

Hi,

To update multiple rows you should use IN operator in where condition. IN operator is used to match multiple records.
e.g
You have to make change in the sql query as follows :

sql="Update jobs SET instructions='"&instructions&"',date='"&date&" where job IN( '"&job&"'")

Here , job variable should contain the list of values to match.

Multiple Data Update

re: Multiple Data Update

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about