I have problem in update the records.
Stn_no, network, assign_to,location,status values came from the dropdown menu.

When I update by ASP page to only stn_no records, it insert NULL value in network, assign_to, location and status fields.
What coding use that when I update only one record It not insert NULL value in remaining fields.
Keep old value in that fields (sql server).

rec_id=Request.Form("rec_id")
stn_no=Request.Form("stn_no")
network=Request.Form("network")
assign_to=Request.Form("assign_to")
location=Request.Form("location")
status=Request.Form("status")

usql1="update stations2 set "
usql2="stn_no='"& stn_no &"',"
usql3="network='"& network &"',"
usql4="assign_to='"& assign_to &"',"
usql5="location='"& location &"',"
usql6="status='"& status &"' where rec_id='"& rec_id &"'"

usql=usql1+usql2+usql3+usql4+usql5+usql6

cn.Execute usql

Mateen