[FX.php List] I need a refresher

[Bob Patin]

That *is* interesting; somewhere in the past I had username & pw backwards and it just didn't do anything at all... but I don't remember what the error message was. In fact, as I think of it, I don't think it returned any error code...


Bob Patin
Longterm Solutions LLC
P.O. Box 3408
Brentwood, TN 37024
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
--
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting
On Dec 8, 2011, at 9:27 PM, Jonathan Schwartz wrote:

> 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/c84e1598/attachment.html