I get "number of supplied values does not match" after I add a clolumn.

[zensunni]

Here's what my code looks like:
=======================================
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "Table", objConn, 1, 3, 2

If Len(Request.Form("AreaID1")) > 0 Then
RS("AreaID1") = Request.Form("AreaID1")
End If

If Len(Request.Form("AreaID2")) > 0 Then
RS("AreaID2") = Request.Form("AreaID2")
End If

RS.Update
=======================================
The code works perfectly, but when I add a column to the table, I get this error:
"Insert Error: Column name or number of supplied values does not match table definition."
If I drop the column, the script works again.

I think it's a problem of the number of supplied values. I don't think it matters if some of the columns are null (IE, I shouldn't have to change my script for adding a new column). But, I've just started using asp a little while ago, so I'm not sure of anything.

Could it have something to do with stored proceedures?

[jhardman]

The code works perfectly, but when I add a column to the table, I get this error:
"Insert Error: Column name or number of supplied values does not match table definition."
If I drop the column, the script works again.

Are you adding a coulmn using some sql statement in an asp? If you are, I would not recommend it. I would definitely use a db manager to add the column. ASP is not designed to be a db manager.

Or are you saying you added a column in a db manager then when you tried to run the same snippet of code in your asp that used to work, it gives you an error? If that is the case, check to make sure the new column only needs to be filled optionally. If the new column is required and you update without giving a value for that field you will get this error.

Or are you saying that you add the column and use a script like this but also including data for the third field? If that is the case, can you show your code?

Jared

[zensunni]

"Are you adding a coulmn using some sql statement in an asp? If you are, I would not recommend it. I would definitely use a db manager to add the column. ASP is not designed to be a db manager."

Yes, I'm using asp to add a column. I can't help it. I'm working remotely and I don't get access to the DB directly. Could that be causing any problems? What should I check for if so? The script that uses the table is separate from the one that adds a column.

"If that is the case, check to make sure the new column only needs to be filled optionally. If the new column is required and you update without giving a value for that field you will get this error."

When you add a column using an sql statement in asp and don't specify any constraints, it shouldn't default to "NOT NULL", should it?

"Or are you saying that you add the column and use a script like this but also including data for the third field? If that is the case, can you show your code?"

I have tried including data for the third field with the same error. I'll post my code tomorrow.

Thanks again for the help.

[zensunni]

Here is my code...
================================================== ===

Set RSCorpIdentity = Server.CreateObject("ADODB.Recordset")
RSCorpIdentity.Open "CorporateIdentity", objConn, 1, 3, 2

CorpID = Request.Form("Update")
'Response.Write "<br>CorpID: " & CorpID
If Len(CorpID) > 0 Then
Update = 1
FBFilter = "ID = " & CorpID
RSCorpIdentity.Filter = FBFilter
Else
RSCorpIdentity.AddNew
End If

If Len(Request.Form("Referrer")) > 0 Then
RSCorpIdentity("Referrer") = Trim(Request.Form("Referrer"))
Else
RSCorpIdentity("Referrer") = 0
End If

If Len(Request.Form("FLCityID")) > 0 Then
RSCorpIdentity("FLCityID") = Request.Form("FLCityID")
End If

If Len(Request.Form("Webdisplay")) > 0 Then
RSCorpIdentity("Webdisplay") = Request.Form("Webdisplay")
End If

RSCorpIdentity.Update

[zensunni]

Is there ever a case where the table can go out of sync with it's table definition?