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

[Michael Layne]

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

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