Microsoft JET Database Engine (0x80040E14)

[minority]

hey tried hard but i be damned if i can find the error to this.


<%
FullName = Request.Form("FullName")
DateOpen = Date()
SourceSelect = Request.Form("Source")
Details = Request.Form("Details")
Descriptionncr = Request.Form("Description")
TypeSelect = Request.Form("Type")
Against = Request.Form("Against")
'response.write(FullName &" "& DateOpen &" "&SourceSelect&" "&Details&" "&Desc&" "&TypeSelect&" "&Against)
'response.end()
set rsinsert = server.CreateObject ("ADODB.Connection")
strSQL = "INSERT INTO Ticket ([Raised_By], [Date_Open], [Source_ID], [Details], [Descriptionncr], [Type_ID], [Raised_Against]) VALUES (" &Fullname& " , " &DateOpen& " , " &SourceSelect& " , " &Details& " , " &Descriptionncr& " , " &TypeSelect& ", " &Against& ")"
rsinsert.open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Intranet\ncr\database\ncr.mdb;User Id=admin;Password=;"
'response.write(strsql)
'response.end()
rsinsert.execute (strSQL)
rsinsert.Close
Set rsinsert = Nothing
Response.Redirect("index.asp")
%>


This is a sample output with response.write
INSERT INTO Ticket ([Raised_By], [Date_Open], [Source_ID], [Details], [Descriptionncr], [Type_ID], [Raised_Against]) VALUES (Paul Phillips , 7/26/2005 , 1 , help , help , 1, 1)

everything is being entered ok but i keep getting this same error
[QUOTE]Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'Paul Phillips'.
/ncr/ncropensql.asp, line 18QUOTE]

[yearbass]

You need to add a single quote in the values, if the data type is string/text or date.

So your strSQL should be :

strSQL = "INSERT INTO Ticket ([Raised_By], [Date_Open], [Source_ID], [Details], [Descriptionncr], [Type_ID], [Raised_Against]) VALUES ('" &Fullname& "' , '" &DateOpen& "' , '" &SourceSelect& "' , '" &Details& "' , '" &Descriptionncr& "' , '" &TypeSelect& "', '" &Against& "')"

I don't know what is your data type in your db (I assumpt you are using text), if it is a number you have to remove the single quote.

[minority]

ok im sure i tried that lol.

thanks

think i only did it for all the numeric fields. instead of all the fields.

thanks again