Hi I am trying to write values to a database, but when using the INSERT
keyword, i get this error : Number of query values and destination fields
are not the same. I have reduced my number of query values and destination
fields to just one so they are definitely the same. Anyone got any ideas? the code is as follows:

<%
If Len(Request.Form("Company")) = 0 Then
   Response.Redirect("addError.asp")
Else
   Set Conn = Server.CreateObject("ADODB.Connection")
   Conn.Open "DSN=AppsDB"

   Company = ReplaceQuotes(Request.Form("Company"))
' Division = ReplaceQuotes(Request.Form("Division"))
' Device = ReplaceQuotes(Request.Form("Device"))
' Engineer = ReplaceQuotes(Request.Form("Engineer"))
' MainIssue = ReplaceQuotes(Request.Form("MainIssue"))
' DateReceived = ReplaceQuotes(Request.Form("DateReceived"))

   strSql = "INSERT INTO MainTable VALUES('" & Company & "')"
   ', '" & Division & "', '" & Device & "', '" & Engineer & "', '" & MainIssue & "', '" & DateReceived & "')"
   Conn.Execute(strSql)

   Conn.Close
   Set Conn = Nothing
End If

Function ReplaceQuotes(strValue)
   strValue = Replace(strValue, "'", "''")

   ReplaceQuotes = strValue
End Function
%>

Hi you might need to specify the database fields before the values in the same order, you should find that this works.

code below from one of my asp pages. - the values sourronded by [] are database fields.

EG: strSQL= "INSERT INTO webdirectory ([Date],[Catagory],[Organization],[Information_On],[URL_Address]) VALUES ('" & (date) & "','" & (catagory) & "','" & (organization) & "','" & (information_on) & "','" & (website_url) & "')"

regards WM


William

Thanks William, tried that but it's now giving me the error Data Type mismatch in type criteria ..... any ideas?

I think the date format is incorrect.
Request.Form("DateReceived") column.


Om Prakash

I agree with Om Prakash - it's something to do with the format of the form/dbase fields. Try removing the date field from the form and then submit the remaining info to the dbase - it's a process of elimination i'm afraid.

William