[FX.php List] Re-That sinking feeling: FileMaker 12 & FX ?

[Bob Patin]

On May 8, 2012, at 2:10 AM, Tim 'Webko' Booth wrote:

> Dear Troy,
> 
>> Unless I really goofed, the spreadsheet shows that the XML from the WPE is messed up.
>> 
>> What seems to be happening is that the XML from the WPE shows all of the expected field names including the field names in the portals, but if any of the portals have NO related records in them, then in the <RESULTSET> section, all of those <COL>...</COL> items are totally omitted, instead of having place-holders in the form of <COL><DATA/></COL>.
>> 
>> Since, in this example record I've been looking at, there are 145 normal + portal fields, and 4 of the 6 portals have no related records, there are way fewer <COL>...</COL> items returned than there should be, so as soon as the first column that has an empty-portal field is encountered, all the data is misaligned. That is, good data from real, filled fields, starts falling in the spots that empty portal columns should be.
>> 
>> Am I being incomprehensible?
>> 
>> Anyway, is this a huge bug in the WPE in FileMaker Server 12? Can anyone reproduce this?
> 
> Can you also check this behaviour on FM11?
> 
> But that would totally suck (and yet another reason that I'm glad I never pull portal data directly, even though it may be inefficient...)
> 
> Maybe Bob could check a copy of the database on his FM12 setup (haven;t got around to it yet...)

Sorry, I've been out of pocket; did you still need to check something, and if so, what do you need me to check?

I have a server up running FMS12 and a few web apps. I ported over a small web app of mine (very small), and one of my clients ported over a fairly large CMS site--so far haven't heard anything from him regarding any bugs, which may just be because neither he nor I are pulling data from portals.

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Twitter: bobpatin
Google+: http://www.longtermsolutions.com/plus
AIM: longterm1954
iChat: bobpatin
--
Expert FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker