[FX.php List] I need a refresher

[Jonathan Schwartz]

Agreed...so how is the Find query getting results using the same flawed parameter setting?

Jonathan Schwartz
Exit 445 Group
415-370-5011

On Dec 8, 2011, at 16:37, Bob Patin <bob at patin.com> wrote:

> Jonathan's exactly right; password first, then username.
> 
> 
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> FileMaker 9, 10 & 11 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --
> Twitter: bobpatin
> Google+: http://www.longtermsolutions.com/plus
> AIM: longterm1954
> iChat: bobpatin
> --
> Expert FileMaker Consulting 
> FileMaker Hosting for all versions of FileMaker
> 
> On Dec 8, 2011, at 6:01 PM, Jonathan Schwartz wrote:
> 
>> John,
>> 
>> Two suggestions:
>> 
>> 1) check the order of parameters for SetDBUserPass. Doesn't the Pass come first?
>> 
>> 2) Reduce the problem query to just an edit request on a single record. Hardcore the recid. At least you will know that you are dealing with a single issue, rather than  one involving a query and edit of multiple records on a loop.
>> 
>> Try that and see where you get. 
>> 
>> Jonathan Schwartz
>> Exit 445 Group
>> 415-370-5011
>> 
>> On Dec 8, 2011, at 11:21, John Funk <jfunk at criticalsolution.com> wrote:
>> 
>>> Hi,
>>> I am a bit rusty at PHP and FX....I have some code below that I need to figure out why I keep getting an error 507 error.
>>> The script works “getting” the three FileMaker records that match the $Item string.
>>> I just cannot figure out why it will not edit the record with the $RecID
>>> Thanks for any help.
>>> John Funk
>>> 
>>> <?php
>>> require_once ('FX/FX.php');
>>> require_once ('FX/server_data.php');
>>> define('DEBUG', True); 
>>> 
>>> //Get Item Info from URL
>>> $Item=$_REQUEST['Item'];
>>> $Date=$_REQUEST['Date'];
>>> 
>>> //echo "Item=".$Item.'<br>';
>>> //echo "Date=".$Date.'<br>';
>>> //exit;
>>> 
>>> //GETTING THE ARRAY OF RECORDS WORKS
>>> $groupSize='10';
>>> $request = new FX($ServerIP, $Port, $DataSourceType);
>>> $request->SetDBData($fmdb,'XML_Items',$groupSize);
>>> $request->SetDBUserPass($fmAccount, $fmPass);
>>> $request->AddDBParam('ItemNumber_Prism', "=".$Item);
>>> $result =$request->FMFind();
>>> $records =$result['data'];
>>> 
>>> foreach($records as $record)
>>> {
>>> $RecID=$record['recid'][0];
>>> $TCIN=$record['ItemNumber_Prism'][0];
>>> $ASIN=$record['ASIN_Prism'][0];
>>> $ImageUploadedDate=$record['ImageUploadedDate'][0];
>>> $Notes=$record['Notes'][0];
>>> 
>>> //EDITING THE EACH RECORD DOES NOT WORK
>>> $request = new FX($ServerIP, $Port, $DataSourceType);
>>> $request->SetDBData($fmdb,'XML_Items',1);
>>> $request->SetDBUserPass($fmAccount, $fmPass);
>>> $request->AddDBParam('-recid', $RecID);
>>> $request->AddDBParam('Notes', ‘TEST’);   //FAILS HERE with 507
>>> $result = $request->FMEdit();
>>> 
>>> }
>>> 
>>> ?>
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> 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
> 
> _______________________________________________
> 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://mail.iviking.org/pipermail/fx.php_list/attachments/20111208/3c3b694d/attachment.html