<% 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")) status = request.form("status") ID = request.form("ID") set objDB = OpenDatabase(false) SQL = "Insert into Leads (FirstName,LastName,JobTitle,Company,Email,BusinessStreet, BusinessStreet2,BusinessCity,BusinessState,BusinessZip,BusinessCountry,BusinessPhone,BusinessCell,BusinessFax,Notes,Notes2, RMComments,PrimaryMarket,SecondaryMarket, LeadSource, DistributorNotes, Status) VALUES ('" &_ FirstName & "','" & LastName & "','" & JobTitle & "','" & Company & "','" & Email & "','" & BusinessStreet & "','" & BusinessStreet2 & "','" & BusinessCity & "','" & BusinessState & "','" & BusinessZip & "','" & BusinessCountry & "','" & BusinessPhone & "','" & BusinessCell & "','" & BusinessFax & "','" & Notes & "','" & notes2 & "','" & rmcomments & "','" & PrimaryMarket & "','" & SecondaryMarket & "','" & leadsource & "','" & distributornotes & "','" & status & "')" UpdateDB objDB, SQL objDB.close set objDB = nothing response.redirect("../leads.asp") %>