RE: [PHP-DB] - Delete records in an Access DB

francesco@automationsoft.biz wrote : > > Fatal error: Call to undefined function: open() in > D:\Inetpub\webs\metagenonlinecom\canc.php on line 11 > I assume the error is match case in open function... Should be $db->Open... etc. -----Original Message----- From: Michael Forbes [mailto:michael.forbes@knology.net] Sent: Monday, May 03, 2004 07:00 To: php-db@lists.php.net Subject: Re: [PHP-DB] - Delete records in an Access DB Nope. Access' version of SQL is a slight bit different from ANSI SQL. All he needs to do in his statement is change it to this: $query="DELETE * FROM Test_Table WHERE name='franco';"; (notice the wildcard in there-- Access isn't smart enough to realize that the deletion of any information in a row automatically means deleting the entire row. I guess the original design must've intended to use delete for an update <columnname> = null.) -Mike Forbes Uzi Klein wrote: > Match Case ? > > -----Original Message----- > From: francesco@automationsoft.biz [mailto:francesco@automationsoft.biz] > Sent: Sunday, May 02, 2004 09:19 > To: php-db@lists.php.net > Subject: [PHP-DB] - Delete records in an Access DB > > > > Hi all, > I have this problem: > I want to delete records in an Access DB. I use this code: > > $query="DELETE FROM Test_Table WHERE name='franco';"; > // the connection parameters > > $path="d:/inetpub/webs/my_site/mdb-database/" ; > > $db_name="test.mdb" ; > > $dsource=$path.$db_name ; > > $cn_string="Provider=Microsoft.Jet.OLEDB.4.0;" ; > > $cn_string.="Data Source=$dsource;" ; > > // connection > > $cn=new COM("ADODB.Connection"); > > $cn->open($cn_string); > > // object Recordset and send query by Open() metod > > $rs=new COM("ADODB.Recordset") ; > > $rs->open($query,$cn) ; > > // clean Recordset object > > $rs->Release() ; > > $rs=null ; > > /* close connection */ > > $cn->Close() ; > > $cn->Release() ; > > $cn=null ; > > > > but I have this error message: > > Fatal error: Call to undefined function: open() in > D:\Inetpub\webs\metagenonlinecom\canc.php on line 11 > > > Where is the problem? Is this the correct way to delete records from an > Access DB? If this is a bad tecnic, can you suggest me what is the correct > way? > > Thanks in advance to all. > > (The server where this script run is a Microsoft server). > > Francesco -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php