Queries return FX_Error Object

[Moe]

I'm new to FX.php, and everything was working great but now if I run a query on a layout that contains fields from a related table I run into trouble. Instead of returning a handy array that is easy to work with an object gets returned that conatins layer on top of layer of other objects and arrays.

I don't know why it was working normally before and now I am having this problem. This is what the beginning of the returned object looks like (it's too long to print the whole thing). Help please!

FX_Error Object

(

[error_message_prefix] =>

[mode] => 1

[level] => 1024

 => 100

[message] => FX: ExecuteQuery XML error: Invalid document end at line 2

[userinfo] =>

[backtrace] => Array

(

[0] => Array

(

[file] => C:InetpubwwwrootFXFX.php

[line] => 1362

[function] => FX_Error

[class] => FX_Error

[object] => FX_Error Object

*RECURSION*

[type] => ->

[args] => Array

(

[0] => ExecuteQuery XML error: Invalid document end at line 2

)

[andygaunt]

One quick question.

Are the fields from the related table directly on the layout or are they in a portal?

[Moe]

They are not in a portal.

[andygaunt]

Moe,

Try placing them in a portal. There can be issues if the related fields are placed directly on the layout, especially if one of the records does not have any related data (was fixed in a recent v rev for FileMaker Server 8 Advanced)

This was more of a problem for people hosting on windows rather than Macs.

[Moe]

That's working! Thanks!