Syntax error in INSERT INTO statement in ASP

[craiogram]

Sorry if I should've asked this elsewhere but b/c it's on my ASP page I'm starting here.

This works:

"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:

"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!

 

[onpnt]

what database are you using? Encapsulation may be the problem

 

[craiogram]

Access DB.

 

[DotNetGnat]

you said the table has 5 cols...but you are trying to insert 6 values...

-DNG

 

[onpnt]

ms access needs dates surrounded by # # then

this one is in the FAQ and mentioned many of many times via the years here in the asp forum. Try using the search and FAQ sections prior to posting questions.

Thanks and hope that helps along with future trouble shooting

 

[craiogram]

I apologize. I is 5 cols when it works in the 1st Insert but has 6 cols in the 2 Insert where it does NOT work.

thank you.

 

[DotNetGnat]

and yes the dates in access db need # delimiter

-DNG

 

[discusmania]

for oracle database you need to convert the date using to_date function.


to_date('"&now()&"','h24:mi:ss mm-dd-yyyy')

hope this helps

regards
Ron