[FX.php List] Related data on separate servers

[Andrew Denman]

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