[FX.php List] delete multiple records at once

[Greg Lane]

Another approach would be to simply change your FMDelete to an FMFind  
and precede it with the following line to tell FMSA to perform a  
script that deletes the found set:

	$delete->AddDBParam('-script','My delete found records script');

Of course, make sure you include appropriate error trapping and test  
thoroughly...a Delete All Records script has the potential to ruin  
your day in a hurry. :)

Greg

On May 13, 2006, at 8:04 PM, Timothy Tait wrote:

> i am using fx.php to connect to a filmaker7 db.  i have a  
> collection page on my website, that consists of multiple records  
> per user.  i have allowed users to remove a single entry from the  
> collection, and would like the ability for them to delete all the  
> entries.
>
> is there a way in fx.php that i can do this?
>
> i have tried
>     $delete=new FX($serverIP, $webCompanionPort, 'FMPro7');
>
>     $delete->SetDBData($dbName, $tableName);
>     $delete->SetDBPassword($password, $username);
>     $delete->AddDBParam('fk_CustomerID', $custID);
>     $deleteResult=$delete->FMDelete(true);