I'm trying to execute the connection object string below but it fails in the ASP page that this code resides. I know it fails because no record gets added to the table. I think it has to do with the vID(the data type is integer) syntax...
-----------------------------------------------------------
sqlText = "insert into tblCustomer(ID, CompanyName, FirstName, LastName,) values (vId,'"& vCompany &"','"& vFirstName &"','"& vLastName &"')"
---------------------------------------------------------
What would be the correct syntax?
Thanks,
ik
-----------------------------------------------------------
sqlText = "insert into tblCustomer(ID, CompanyName, FirstName, LastName,) values (vId,'"& vCompany &"','"& vFirstName &"','"& vLastName &"')"
---------------------------------------------------------
What would be the correct syntax?
Thanks,
ik