[FX.php List] PerformFMScript problem...

[Joel Shapiro]

Hey Bob

I think you'd want to use PerformFMScript, not PerformFMScriptPrefind  
since you want the script to run on the found results.

-Joel


On Oct 22, 2010, at 12:11 PM, Bob Patin wrote:

> Here's the code:
>
> $query3 = new FX($serverIP,$webCompanionPort, $dataType, $scheme);
> $query3->setDBData('<database>','web_pub_orders');
> $query3->SetDBPassword($webPW,$webUN);
> $query3->AddDBParam('Client_ID',$ClientID);
> $query3->PerformFMScriptPrefind('web_perform_relookup');
> $query3Result = $query3->FMFind();
>
> Not much to look at...
> I've tried both the existing script and also PerformFMScript() with  
> the same results...
>
> Going to try pasting all the fields onto the layout now to see what  
> that does...
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> iChat: bobpatin
> FileMaker 9, 10 & 11 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --
> Expert FileMaker Consulting
> FileMaker Hosting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
> :
>
> On Oct 22, 2010, at 12:53 PM, Joel Shapiro wrote:
>
>> Hey Bob
>>
>> I'll nibble...
>>
>> - Do you have a Commit step pre-relookup?
>> - Are you sure you're using the post-find script command?
>> - Wanna share your query/script code?
>> - FX or API?
>>
>> -Joel
>>
>>
>> On Oct 21, 2010, at 1:16 PM, Bob Patin wrote:
>>
>>> I posted this 3 days ago, but no one nibbled...
>>>
>>> Anyone have any solutions for this?
>>>
>>> Thanks,
>>>
>>>
>>>
>>> <new_logo_idea3_120w.jpg>
>>>
>>> Longterm Solutions
>>> bob at longtermsolutions.com
>>> 615-333-6858
>>> http://www.longtermsolutions.com
>>> iChat: bobpatin
>>> FileMaker 9, 10 & 11 Certified Developer
>>> Member of FileMaker Business Alliance and FileMaker TechNet
>>> --
>>> Expert FileMaker Consulting
>>> FileMaker Hosting for all versions of FileMaker
>>> PHP • Full email services • Free DNS hosting • Colocation •  
>>> Consulting
>>> :
>>>
>>> <PastedGraphic-1.tiff>
>>>
>>>
>>>
>>> On Oct 18, 2010, at 3:36 PM, Bob Patin wrote:
>>>
>>>> I've got a script that I want to trigger after doing a FIND(); it  
>>>> performs a relookup so that I can pull some data from a record.
>>>>
>>>> I didn't write this database, so this isn't how I'd normally do  
>>>> this, but I'm stuck with it and can't get it to work. Here's what  
>>>> I've determined:
>>>>
>>>> 1. When I write the record and enter the clientID, this *should*  
>>>> cause lookups to occur on about 10 fields; nothing happens.
>>>>
>>>> 2. I tried putting in a script, which I could trigger in my FIND  
>>>> script on the web; to make sure it's firing, I also added a field  
>>>> called "test" and told my script to set that field to 1.
>>>>
>>>> The field "test" does get set to 1, but even though I have a  
>>>> PERFORM RELOOKUP() step, and I've properly navigated to the right  
>>>> layout and isolated the proper record, it doesn't relookup.
>>>>
>>>> Anyone come up against this? If so, how can I get this to work?
>>>>
>>>> Thanks,
>>>>
>>>>
>>>> Bob Patin
>>>> Longterm Solutions
>>>> bob at longtermsolutions.com
>>>> 615-333-6858
>>>> http://www.longtermsolutions.com
>>>> iChat: bobpatin
>>>> FileMaker 9, 10 & 11 Certified Developer
>>>> Member of FileMaker Business Alliance and FileMaker TechNet
>>>> --
>>>> Expert FileMaker Consulting
>>>> FileMaker Hosting for all versions of FileMaker
>>>> PHP • Full email services • Free DNS hosting • Colocation •  
>>>> Consulting
>>>>
>>>> _______________________________________________
>>>> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list