The statement has been terminated.
String or binary data would be truncated.
I get An error message on this line of code
Sqlupdate.UpdateCommand = "UPDATE LILOCATIONS Set LOCWNAME = '" & Server.HtmlEncode(txtlocwname.Text) & "', LOCNM = '" & Server.HtmlEncode(txtlocnw.Text) & "', ADDR1 = '" & Server.HtmlEncode(txtaddr1.Text) & "', ADDR2 = '" & Server.HtmlEncode(txtaddr2.Text) & "', ADDR3 = '" & Server.HtmlEncode(txtaddr3.Text) & "', CITY = '" & Server.HtmlEncode(txtcity.Text) & "', ZIP = '" & Server.HtmlEncode(txtzip.Text) & "', COUNTRY = '" & Server.HtmlEncode(txtcountry.Text) & "', PHN = '" & Server.HtmlEncode(txtphn.Text) & "', LOCNM2 = '" & Server.HtmlEncode(txtlocnm2.Text) & "', PHNEXT = '" & Server.HtmlEncode(txtphnext.Text) & ...
Go to the complete details ...