[FX.php List] record won't delete

Edward L. Ford elford at cs.bu.edu
Sun Aug 20 20:13:19 MDT 2006


This is a "Why didn't I think of that?" moment.  Thanks for the tip, 
that was exactly the problem.

Jonathan Schwartz wrote:
> Does the FMP Privilege Set associated with your Account allow Deletion 
> of records?
>
>
> Jonathan
>
> At 5:58 PM -0400 8/20/06, Edward L. Ford wrote:
>> Jonathan,
>> Yes, that one var always gets set to 1, no matter what currently.
>>
>> I forgot about that DEBUG definition at the top of the file.  I now 
>> see I'm getting error 200: Record Access is denied.  The debug URL 
>> reads:
>> <Server_Address>/fmi/xml/FMPXMLRESULT.xml?-db=MusicianList.fp7&-lay=Musicians_Web&-max=50&-recid=69&-delete 
>>
>> I'm not sure how this is possible -- the page before accesses the 
>> record's data and presents it to the client just fine.  Recid=69 is 
>> the right record that I want to delete.
>>
>> Other records aren't being deleted either, my record count is the 
>> same before and after the deletion attempt.
>> --Ed F.
>>
>> Jonathan Schwartz wrote:
>>> Edward,
>>>
>>> It looks to me that the $Delete variable to set to "1" whether or 
>>> not the operation is successful.  No?
>>>
>>> Have you checked for error?  Also, have to looked at the query using 
>>> "define("DEBUG", true);"
>>> to see what FMP is receiving?
>>>
>>> One more idea, if there is no error, perhaps the delete is getting 
>>> the wrong record?  Check your record count before and after.
>>>
>>> HTH,
>>>
>>> Jonathan
>>>
>>> At 5:10 PM -0400 8/20/06, Edward L. Ford wrote:
>>>> Hello,
>>>> I'm attempting to get a record to delete, but it refuses to do so 
>>>> with the following code:
>>>>      # Needs the record ID to edit or delete a record
>>>>    $EditRecord->AddDBParam('-recid', stripslashes($_POST['RecID']));
>>>>      # Declare all inputs from HTML form
>>>>    if(! (strstr($_POST['delete'], 'Yes') === FALSE)) {
>>>>        $EditRecord -> FMDelete();
>>>>        # Set a delete flag (Used to display delete confirmation 
>>>> later on)
>>>>        $Delete = 1;
>>>>    }
>>>> I know the block with the delete command is entered because I get 
>>>> the delete confirmation message -- but the record is still in the 
>>>> database.  I also tried $EditRecord -> FMDelete(true); which did 
>>>> not work.
>>>>
>>>> Anyone see my mistake?
>>>> Thanks,
>>>> --Ed Ford
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>


More information about the FX.php_List mailing list