[FX.php List] record won't delete

Edward L. Ford elford at cs.bu.edu
Sun Aug 20 15:58:44 MDT 2006


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
>
>


More information about the FX.php_List mailing list