* Thus wrote Joe Mack ([EMAIL PROTECTED]):
> I am getting no error messages or anything, but when I browse the database,
> my changes are not being posted. Here is an example of what I am trying to
> do. Hopefully, I am just missing a step along the way.
ensure that your error_reporting and display errors is on.
>
> $dbFile = '\\\\SERVER\\FOLDER\\BackEnd.mdb';
Inside single quotes the \\ does NOT get translated to \
> $conn = new COM('ADODB.Connection');
> $conn->Open("DRIVER=Microsoft Access Driver (*.mdb);DBQ=$dbFile");
> $cmd = new COM('ADODB.Command');
> $cmd->ActiveConnection = $conn;
> $cmd->CommandText = "UPDATE TABLE1 SET FIELD1 = '$parm1' WHERE FIELD2 =
> '$parm2';";
ensure this sql statement is proper. try echoing it out and seeing
if it is correct (particularly the $parm2)
> $cmd->Prepared = TRUE;
> $RSet = $cmd->Execute();
>
> Any assistance anyone can offer would be greatly appreciated. Thank you.
I'm not familiar with ADO and php so i can't give advice on that
end.
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
