<% FirstName = fixsql(request.form("firstname")) LastName = fixsql(request.form("lastname")) JobTitle = fixsql(request.form("jobtitle")) Company = fixsql(request.form("company")) Email = fixsql(request.form("email")) BusinessStreet = fixsql(request.form("businessstreet")) BusinessStreet2 = fixsql(request.form("businessstreet2")) BusinessCity = fixsql(request.form("businesscity")) BusinessState = fixsql(request.form("businessstate")) BusinessZip = fixsql(request.form("businesszip")) BusinessPhone = fixsql(request.form("businessphone")) BusinessCell = fixsql(request.form("businesscell")) BusinessFax = fixsql(request.form("businessfax")) Notes = fixsql(request.form("notes")) Notes2 = fixsql(request.form("notes2")) rmcomments = fixsql(request.form("rmcomments")) PrimaryMarket = fixsql(request.form("primarymarket")) SecondaryMarket = fixsql(request.form("secondarymarket")) leadsource = fixsql(request.form("leadsource")) distributornotes = fixsql(request.form("distributornotes")) ID = request.form("ID") set objDB = OpenDatabase(false) SQL = "Update Leads set FirstName = '" & firstname & "', LastName = '" & lastname & "', JobTitle = '" & jobtitle & "', Company = '" & company & "', Email = '" & email & "', BusinessStreet = '" & businessstreet & "', BusinessStreet2 = '" & businessstreet2 & "', BusinessCity = '" & businesscity & "', BusinessState = '" & businessstate & "', BusinessZip = '" & businesszip & "', BusinessCountry = '" & businesscountry & "', BusinessPhone = '" & businessphone & "', BusinessCell = '" & businesscell & "', BusinessFax = '" & businessfax & "', Notes = '" & notes & "', Notes2 = '" & notes2 & "', RMComments = '" & rmcomments & "', PrimaryMarket = '" & primarymarket & "', SecondaryMarket = '" & secondarymarket & "', LeadSource = '" & leadsource & "', distributornotes = '" & distributornotes & "', LastUpdated = '" & now & "' where ID = '" & ID & "'" UpdateDB objDB, SQL objDB.close set objDB = nothing response.redirect("../leads.asp") %>