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 |
