[FX.php List] Related data on separate servers

[Anders Monsen]

Thanks, Beverly. I had hoped to run it all in one query. At least I now 
can confirm with the direct query to the second server that PHP is able 
to see and return the data, so I'll use the process that works.

Anders

On 5/15/12 10:32 AM, BEVERLY VOTH wrote:
> Since the 'server/host' is part of the query (to get the data), I'd say YES, you need another query for that related data. :)
>
> Beverly
>
>
> On 15 May 2012, at 11:26 AM, Anders Monsen wrote:
>
>> I'm having an issue getting related data using FX. The setup is as follows.
>>
>> Two servers. Server 1 has multiple files. I have a layout on one file that has related data from other files on Server 1. These show up as expected in the PHP page.
>>
>> Also, I have related data from Server 2 showing up in the FMP layout on Server 1. This does not show up in PHP. There is a web enabled account with same access on Server 2 as Server 1. I looked at the primary array, which shows data on the FMP layout, and not one instance of Server 2 fields appear in this array.
>>
>> Will I need a separate query to Server 2 on the same page, or should I be able to see the related data on the second server from the main server FMP layout?
>>
>> Thanks,
>> Anders Monsen
>> _______________________________________________
>> 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
>
>