[FX.php List] Records not being Updated after going from FM 6 to FMSA 7

[Earl Cook]

Hi Michael,

Thanks!   

Changing ­recID to ­recid did it.  Arrggg!  I had forgotten that in the time
away.

Earl


on 12/20/05 3:13 PM, Michael Layne at fx at 9degrees.com wrote:

> Hi Earl,
> 
> Check the case of '-recID'.  I think it has to be '-recid' in 7.  Also, you
> are passing a value for a password, which you didn't have before, so check
> that as well.
> 
> HTH,
> 
> Michael
> 
> On Dec 20, 2005, at 12:14 PM, Earl Cook wrote:
> 
>> My PHP code worked in FMP 6.0 but now records are not being updated in FMSA
>> 7 on Mac OS X. 
>> 
>> I am finding the record and can return values from it, but no update of the
>> record is occurring. 'Admin' has full privileges. I created a new layout
>> with just the fields shown.
>> 
>> Thanks,
>> Earl
>> 
>> <?php
>> 
>>     include ("FX.php");
>> 
>>     $ip = "127.0.0.1";
>>     $port = "80";
>>     $db = "members";
>>     $lay = "web_detail2";
>> 
>>     $queryfind = new FX($ip,$port);
>>     $queryfind->SetDBData($db,$lay);
>>     $queryfind->SetDBPassword('pass','Admin');
>> 
>>     $queryfind->AddDBParam('memRecID', $_POST['memRecID']);
>> 
>>     $result = $queryfind->FMFind();
>> 
>>     $data = current($result['data']);
>>         $recID0 = explode ('.', key($result['data']));
>>         $recID = $recID0[0];
>> 
>> // When activated the following echo returns 1 record found, so the record
>> is being found.
>> 
>> // echo $result['foundCount'] . " Member records found.";
>> 
>> //This is where the update occurs
>> 
>>     $queryedit = new FX($ip,$port);
>>     $queryedit->SetDBData($db,$lay);
>>     $queryedit->SetDBPassword('pass','Admin');
>> 
>>     $queryedit->AddDBParam('-recID', $recID);
>>     $queryedit->AddDBParam('memVal', $_POST['memVal']);
>> 
>>     $result = $queryedit->FMEdit();
>> 
>> // The following echo returns the correct memRecID for the found record, but
>> memVal for the record is not being updated.
>> 
>>     echo $data['memRecID'][0];
>> 
>> ?>
>> 
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>  
> 
>  
> 
> 
>  
> 
> Michael Layne  :  9 degrees development  :  www.9degrees.com  :  404.226.7835 
>   
> 
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20051220/7f7bbe63/attachment.html