OK, this is the source of my frustration today (PHP4, MS Access, Windows server, by the way):
This insert statement works:
INSERT INTO parts (name) VALUES ('$name')
This one, however, does not:
INSERT INTO parts (name, desc) VALUES ('$name','$desc')
All the field names are correct, and they all work if I try to insert them individually. It's only when I try to perform a standard multi-field insert that the page stalls -- no error message, just stalls loading the insert page from the form. The associated code is as follows:
if (!$conn = new COM("ADODB.Connection"))
exit("Unable to create an ADODB connection<br>");
$strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("parts1.mdb");
$conn->open($strConn);
$strSQL = "INSERT INTO parts (name) VALUES ('$name')";
$rs = $conn->execute($strSQL);
If you know anything about this or can help, I'd be something beyond excited. I've never seen anything quite like this, and boy has it consumed a lot of my time -- good grief Charlie Brown.
-Jay
