[FX.php List] record won't delete

[Jonathan Schwartz]

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


-- 

Jonathan Schwartz
FileMaker 8 Certified  Developer
Associate Member, FileMaker Solutions Alliance
Schwartz & Company
jonathan at eschwartz.com
http://www.eschwartz.com
http://www.exit445.com