[FX.php List] Related data on separate servers

[Anders Monsen]

I made sure #2 is set up this way, but there is one query to the FMP db, 
and that uses the server 1 domain name. I wasn't sure if the fact that 
the server 2 is in the graph in the server 1 file and the field is in a 
portal on the web layout would let it work, but I must have missed 
something. I decided to cut through the knot and write a 2nd query 
instead. We'll see if there's unexpected overhead.

Anders

On 5/15/12 12:13 PM, Andrew Denman wrote:
> It's been a long time since I've used a two server setup like this, but I remember that this should work.  Points of failure off the top of my head are:
>
> 1) How the external data source is linked. Try using an IP address if it doesn't specify one already.
> 2) The account username and password you are using from the web must match exactly between the two files.
>
> I don't have a way to test this, so if neither of those are the issue dual queries sounds like the best solution.
>
> Andrew Denman
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Anders Monsen
> Sent: Tuesday, May 15, 2012 10:49 AM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Related data on separate servers
>
> 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
>>
>>
> _______________________________________________
> 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
>
>