need help with insert code

Two tables to insert, one works

[txbakers]

I'm baffled. I have actually three tables to update, two update fine. When I leave the third set of code in the page fails. When I remove the code it works.

Will someone PLEASE look over these two segments and see what I did wrong?

Good table insert:
// insert into Students (table2)
var MM_tableValues = "", MM_dbValues = "";
for (var i=0; i+1 < MM_fields2.length; i+=2) {
var formVal = MM_fields2[i+1];
var MM_typesArray = MM_columns2[i+1].split(",");
var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
if (formVal == "" ¦¦ formVal == "undefined") {
formVal = emptyVal;
} else {
if (altVal != "") {
formVal = altVal;
} else if (delim == "'") { // escape quotes
formVal = "'" + formVal.replace(/'/g,"''") + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_tableValues += ((i != 0) ? "," : "") + MM_columns2[i];
MM_dbValues += ((i != 0) ? "," : "") + formVal;
}
MM_editQuery = "insert into " + editTable2 + " (" + MM_tableValues + ") values (" + MM_dbValues + ")";

if (!MM_abortEdit) {
// execute the insert
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();

//if (MM_editRedirectUrl) {
//Response.Redirect(MM_editRedirectUrl);
//}
}

BAD TABLE INSERT:
// insert into StuDetail
var MM_tableValues = "", MM_dbValues = "";
for (var i=0; i+1 < MM_fields.length; i+=2) {
var formVal = MM_fields[i+1];
var MM_typesArray = MM_columns[i+1].split(",");
var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
if (formVal == "" ¦¦ formVal == "undefined") {
formVal = emptyVal;
} else {
if (altVal != "") {
formVal = altVal;
} else if (delim == "'") { // escape quotes
formVal = "'" + formVal.replace(/'/g,"''") + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_tableValues += ((i != 0) ? "," : "") + MM_columns[i];
MM_dbValues += ((i != 0) ? "," : "") + formVal;
}
MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ") values (" + MM_dbValues + ")";

if (!MM_abortEdit) {
// execute the insert
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();

//if (MM_editRedirectUrl) {
//Response.Redirect(MM_editRedirectUrl);
//}

}

[txbakers]

More info: it appears to be a problem with the table itself - studetail. I just did a quick barebones insert form and it worked on one table, but not studetail.

Why would a table give me grief? Are there permissions, maximum records?

[txbakers]

Well, it's 1AM in Dallas and it turns out it was the data type of a field causing all the grief. What is the problem with date fields in Access and asp? I changed it back to text and it works fine now.

[bmcgee]

If you have a field type of "Date" in Access, you need to put "#" before and after it.

e.g.
Insert INTO mytable (mydatefield) values (#11/4/2001#)

Just like you need ticks around a string data type...