[FX.php List] PerformFMScript problem...

[Anders Monsen]

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20101022/725fe664/attachment-0001.html