Hi all, i need help on asp-sql code.
I have a form when I catch some infos and i want to create a new record into a database.
I have tried many syntax but I can't pass the variables a,b,c,d,e,f to sql string.
Please tell me how can i do it.
<% a=Request.Form("LastName"); b=Request.Form("FirstName"); c=Request.Form("Street"); d=Request.Form("City"); e=Request.Form("Country"); f=Request.Form("Phone"); Response.write (a+" "+b+" "+c+" "+d+" "+e+" "+f); var sSQLString; sSQLString = "INSERT INTO tAuthors (LastName, FirstName, Street, City, Country, Phone) VALUES (a,b,c,d,e,f);" con.Execute(sSQLString); %>
Thanks in advance, Roby.