[FX.php List] Workaround for Portal Bug in Recent Versions of FMS

[Kevin Futter]

But how do you make multiple queries using only a single connection? This
element has me puzzled, so I¹d love some clarification, especially given
the performance issues we¹ve been suffering with FM web output lately.

Kev

On 25/01/2015 2:32 pm, "Beverly" <beverlyvoth at gmail.com> wrote:

>I didn't say multiple connections I said multiple queries. Does that help?
>This is the same method I use to SQL dbs.
>
>-- sent from myPhone --
>Beverly Voth
>--
>
>> On Jan 24, 2015, at 6:54 PM, Malcolm Fitzgerald
>><malcolm at notyourhomework.net> wrote:
>>
>> Beverly,
>>
>> Don't you find that the need to make multiple connections imposes time
>>penalties?
>>
>> I began doing all the work, ie, query parent, query related tables, but
>>I'm now putting portals onto layouts and getting better performance.
>>Admittedly, this is done on small related record sets.
>>
>> Malcolm
>>
>>> On 25/01/2015 12:41 pm, Beverly wrote:
>>> Yes. Query and display the parent. Query and display as many "portals"
>>>as needed by taking the parent primary key to match the child foreign
>>>key.
>>>
>>> -- sent from myPhone --
>>> Beverly Voth
>>> --
>>>
>>>> On Jan 24, 2015, at 2:10 PM, Philip Lamb <phil at eden.net.nz> wrote:
>>>>
>>>> Beverly,
>>>>
>>>> Can you explain a little more about this technique? I used portal
>>>>fields as a convenient way to query multiple tables with a single
>>>>query. Do you make multiple requests using the foreign key technqiue?
>>>>
>>>> Regards,
>>>> Phil.
>>>>
>>>>> On 24/01/2015, at 5:47 AM, BEVERLY VOTH <beverlyvoth at gmail.com>
>>>>>wrote:
>>>>>
>>>>> I tend to skip portals altogether on the web and just get the data
>>>>>using the foreign key. Which is another option for those who hate the
>>>>>portal-bug. :)
>>>> _______________________________________________
>>>> 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



[http://www.sbc.vic.edu.au/assets/images/email_logo.gif]

St Bernard's College
Celebrating 75 Years of Achieving Excellence By Learning And Doing
Kevin Futter
Webmaster
Ph: +61392891095 | Mobile:
Email: KFutter at sbc.vic.edu.au<mailto:KFutter at sbc.vic.edu.au>
41 Rosehill Road, Essendon, Victoria, 3040 | Ph: 03 9289 1000 | F: 9337 1741 | www.sbc.vic.edu.au<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.