hello,
for string s you have to put "" for inserting into database.ok.like
if first name, last name and address is strings the syntex will come
like this ok
SQL = "INSERT INTO mytab
(number,lname,fName,address,city,state,phone,parents) values ( " & _
Request.Form("number") & " , " & _
request.Form("lastname") & " , " & _
Request.Form("firstname") & " , " & _
Request.Form("address") & " , " & _
Request.Form("city") & " , " & _
Request.Form("state") & " , " & _
Request.Form("phone") & " , " & _
Request.Form("parents") & " ) "
try this and let me know the result
regards,
jijo
|