Hi,
I have a problem with an insert into ms sql(web-based).
I keep getting an error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ';'.
/admin/dataentry2.asp, line 147
the actual code the asp page is
function addRecord()
v_Name = replace(Request.Form("Name"), "'", "\'")
v_Category = replace(Request.Form("Category"), "'", "\'")
v_Address1 = replace(Request.Form("Address1"), "'", "\'")
v_Address2 = replace(Request.Form("Address2"), "'", "\'")
v_Phone1 = replace(Request.Form("Phone1"), "'", "\'")
v_Phone2 = replace(Request.Form("Phone2"), "'", "\'")
v_Responsable1 = replace(Request.Form("Responsable1"), "'", "\'")
v_Responsable2 = replace(Request.Form("Responsable2"), "'", "\'")
v_Fax = replace(Request.Form("Fax"), "'", "\'")
v_Description = replace(Request.Form("Description"), "'", "\'")
v_Classification = replace(Request.Form("Classification"), "'", "\'")
v_EMail = replace(Request.Form("EMail"), "'", "\'")
v_Adds = replace(Request.Form("Adds"), "'", "\'")
v_Url = replace(Request.Form("Url"), "'", "\'")
v_Area = Request.Form("Area")
v_booleanValue = Request.Form("booleanValue")
if (v_Name <> "" and v_Category <> "") then
sql = "INSERT INTO tblListing('Name', 'Category','Address1','Address2','Phone1';'Phone2','Responsable1','Responsable2','Fax','Description','Classification','EMail','Adds','Url','AreaId','booleanValue')" &_
"Values('"&v_Name&"', '"&v_Category&"', '"&v_Address1&"', '"&v_Address2&"', '"&v_Phone1&"', '"&v_Phone2&"', '"&v_Responsable1&"', '"&v_Responsable2&"', '"&v_Fax&"', '"&v_Description&"', '"&v_Classification&"', '"&v_EMail&"', '"&v_Adds&"', '"&v_Url&"', "&v_Area&", "&v_booleanValue&")"
openconnection
conn.Execute sql
conn.close
set conn = nothing
if anyone can help me with this, I'd be very thankful