[FX.php List] PerformFMScript problem...

[Bob Patin]

no, because this doesn't use the API, and also, this is running on someone else's servers, and a database that I didn't write.

I don't want to mix FX & the API; I suppose I *could* but the FX script command has always worked for me in the past for other things.

Bob





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 2:13 PM, Anders Monsen wrote:

> Have you considered the PHP API script command as an option?
> 
> --
> Anders Monsen
> 
> 
> On 10/22/10 2:11 PM, "Bob Patin" <bob at patin.com> 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 <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
> 
> This message and any attachments are intended only for the use
> of the intended recipient and may contain information that is
> privileged and confidential. If the reader of the message is not the
> intended recipient or an authorized representative of the intended
> recipient, you are hereby notified that distribution, disclosure,
> printing, copying, storage, modification or the taking of any action
> in reliance upon this transmission is strictly prohibited. Delivery of
> this message to any person other than the intended recipient shall
> not compromise or waive such confidentiality.  If you have received
> this communication in error, notify the sender immediately by
> return email and delete the message and any attachments from
> your system. Messages sent to or from this contact will be
> recorded and are subject to archival, monitoring, and/or disclosure
> to someone other than the recipient.
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
Skipped content of type multipart/related