[FX.php List] PerformFMScript problem...

[Bob Patin]

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

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