[FX.php List] Related field issue

[Jon Montgomery]

Kevin,

I have had this problems on my one web project.  The only way I ever got around it, and you have done more than I ever did trying to fix it, was to put a Portal on that layout with the data I need.  However, I believe I was in the API then and not FX.

Could you not make a call directly to the table on File B and not mess with a portal?  I have not had to do that yet, but I read many posts by Tim "Webko" Booth, and my guess is he would tell me to do that.  Just have not convinced myself that I am smart enough to make that work.

I read every post from you guys on these emails.  You guys are so sharp on this stuff.  

Not sure this helps but I hope so.

Jon Montgomery
Illinois Grade School Music Association


On Aug 21, 2012, at 11:48 PM, Kevin Futter wrote:

> Hi folks,
> 
> I've got a weird problem I'm hoping someone can help me with. I'm pulling data out of a table in File A using FX. Today I decided I needed some data out of a field in related File B, so I put that field on the web layout of File A. I ensured all the permissions were correct at both ends, and even logged into File A as the FX web user (to which I gave 'fmapp' privileges), and the data is visible on the layout.
> 
> BUT! When I pull the data out of that layout via FX, I get an empty array element for that field. It doesn't even read the field name for the array index. In desperation, and I added a calculation field to the table in File A that resolves to the data I want from File B. Again, it passes all the tests I did for the pure related field, but still no joy. The only difference is that this time I get the field name in as the array index, but still no data.
> 
> I have absolutely no idea what's going on! Normally this sort of thing indicates a permissions issue with the related file, but I've opened everything up on both sides of the relationship, and have proved that the web user can 'see' the related data.
> 
> Any clues?
> 
> Thanks in advance,
> 
> Kev
> 
> --
> Kevin Futter
> Webmaster, St. Bernard's College
> http://www.sbc.vic.edu.au/
> This e-mail and any attachments may be confidential. You must not disclose or use the information in this e-mail if you are not the intended recipient. If you have received this e-mail in error, please notify us immediately and delete the e-mail and all copies. The College does not guarantee that this e-mail is virus or error free. The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The content and opinions in this e-mail are not necessarily those of the College.
> _______________________________________________
> 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/20120822/ca1d6965/attachment.html