[FX.php List] Extra content at the end of the document

[Gareth Evans]

If your query is returning multiple records try querying just the first and
second records separately. If the XML is truncated for one but not the other
then it is an issue with that particular record. If the XML is truncated for
both I then I would check to see if they are truncated to the same length
(maybe a character limit somewhere) or to the same node (field content or
name issue?).

This should at least help you narrow down the possible cause.
-- 
GARETH EVANS


> From: Jonathan Schwartz <jschwartz at exit445.com>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Tue, 28 Oct 2008 10:44:20 -0700
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: Re: [FX.php List] Extra content at the end of the document
> 
> Great suggestion.  I had to dig a bit under the surface to find the
> XML because Safari was reporting the error and hiding it.
> 
> The XML output is essentially halting midway through the first record.
> 
> I was able to eliminate the error by eliminating the related fields
> from the layout.
> 
> So, I am now trying to figure out why related record from one table
> to the next are crashing the XML.
> 
> ggt suggested utf-8.
> 
> Is there anything inside of FileMaker that needs to be set to accomodate
> utf-8?
> 
> J
> 
> 
> At 12:50 PM -0400 10/28/08, Gareth Evans wrote:
>> Run the XML through a validator to see what it's failing on. It may just be
>> a character is not being escaped properly.
>> --
>> GARETH EVANS
>> 
>> 
>>>  From: Jonathan Schwartz <jschwartz at exit445.com>
>>>  Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
>>>  Date: Tue, 28 Oct 2008 09:36:55 -0700
>>>  To: <fx.php_list at mail.iviking.org>
>>>  Subject: [FX.php List] Extra content at the end of the document
>>> 
>>>  Hi Folks,
>>> 
>>>  This is new one.
>>> 
>>>  Receiving an error when trying to access one table of a solution:
>>> 
>>>  error on line 1 at column 892: Extra content at the end of the document
>>> 
>>>  All other tables work fine.  Occurs with all layouts on this
>>> particular table.
>>> 
>>>  Google search reveals it is related to an XML error, and I have no
>>>  idea where to start looking.
>>> 
>>>  Any ideas?
>>> 
>>>  In this case, the db belongs to a fellow developer, and I will
>>>  probably need to prove the problem is in the DB and not my fx.php
>>>  access. ;-)
>>> 
>>>  J
>>>  --
>>>  Jonathan Schwartz
>>>  Exit 445 Group
>>>  jonathan at exit445.com
>>>  http://www.exit445.com
>>>  415-370-5011
>>>  _______________________________________________
>>>  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
> 
> 
> -- 
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list