Sorry if I should've asked this elsewhere but b/c it's on my ASP page I'm starting here.
This works:
But this does NOT work:
I've also tried to do the response.write(query) and it looks fine. All the values show up. The table has the 5 cols. The 1st 4 are text and the 5th was date/time but I changed it to text as well to see if it would work but nothing.
Any help would be greatly appreciated.
Thank you much!
This works:
Code:
"INSERT INTO meltingPot(uname,fname,lname,email,password)" & _
"Values('" & (Request.Form("uname")) & "'," & _
"'" & (Request.Form("fname")) & "'," & _
"'" & (Request.Form("lname")) & "'," & _
"'" & (Request.Form("email")) & "'," & _
"'" & Request.Form("pswd") & "')"
But this does NOT work:
Code:
"INSERT INTO meltingPot(uname,fname,lname,email,password,TimeStamp)" & _
"Values('" & (Request.Form("uname")) & "'," & _
"'" & (Request.Form("fname")) & "'," & _
"'" & (Request.Form("lname")) & "'," & _
"'" & (Request.Form("email")) & "'," & _
"'" & (Request.Form("pswd")) & "'," & _
"'" & (now()) & "')"
I've also tried to do the response.write(query) and it looks fine. All the values show up. The table has the 5 cols. The 1st 4 are text and the 5th was date/time but I changed it to text as well to see if it would work but nothing.
Any help would be greatly appreciated.
Thank you much!