[FX.php List] Workked on a Mac but not on a PC

[Chris Hansen]

John,

Is that the entirety of the XML that you get?  If so, there's the  
problem -- the XML isn't closed properly.  My guess is that there's a  
character (possibly invisible) in there that is forbidden by XML.   
FileMaker has gotten increasingly good about handling this as versions  
have progressed, so it doesn't surprise me that an XML problem would  
crop up when you went backwards.  Also, Windows tends to be worse  
about invisible characters, in my experience, so there's something of  
a double whammy here.

So... the fix... you know in which record the problem is -- Record ID  
102 -- and you know in which field (most likely) the problem lies  
since output died before it -- Skaters_Sessions::Testdata.  Have a  
look in there and see what you find.

HTH

--Chris

On Feb 19, 2009, at 8:30 AM, John Funk wrote:

> I have a very simple html login page that asks for a member number  
> and a php file that finds the entered member and displays the member  
> info.
> The problem is, this worked on a Mac/ FileMaker Server Advance 9  
> test system and now I moved it to a PC (XP) FileMaker Server Advance  
> 8 system (with iis) and the result does not work. But IWP does work  
> so the config is good.
>
> This is the xml error I get:
>
> XML Parsing Error: no element found
> Location: http://webuser:webpass@192.168.1.3/fmi/xml/FMPXMLRESULT.xml?-db=RFSC+Sessions.fp7&-lay=WEB_Skaters&-max=1&SkaterNumber=%3D%3D1010&-find
> Line Number 1, Column 1496:
>
>
> This is the XML result from the debug url:
>
> <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE  
> FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "/fmi/xml/ 
> FMPXMLRESULT.dtd"><FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult 
> "><ERRORCODE>0</ERRORCODE><PRODUCT BUILD="11/14/2005"  
> NAME="FileMaker Web Publishing Engine" VERSION="8.0.2.65"/><DATABASE  
> DATEFORMAT="MM/dd/yyyy" LAYOUT="WEB_Skaters" NAME="RFSC  
> Sessions.fp7" RECORDS="77" TIMEFORMAT="HH:mm:ss"/><METADATA><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="SkaterNumber" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="First" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="MI" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="Last" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="Sessions" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="Season" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="Year" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="Skaters_Sessions::Season"  
> TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"  
> NAME="Skaters_Sessions::SkaterNumber" TYPE="TEXT"/><FIELD  
> EMPTYOK="YES" MAXREPEAT="1" NAME="Skaters_Sessions::SessionNumber"  
> TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"  
> NAME="Skaters_Sessions::Testdata" TYPE="TEXT"/></METADATA><RESULTSET  
> FOUND="1"><ROW MODID="25" RECORDID="102"><COL><DATA>1010</DATA></ 
> COL><COL><DATA>Emma</DATA></COL><COL><DATA></DATA></ 
> COL><COL><DATA>Erler</DATA></COL><COL><DATA></DATA></ 
> COL><COL><DATA>Winter</DATA></COL><COL><DATA>2008</DATA></COL><COL></ 
> COL><COL></COL><COL></COL>
>
> Is this an iis problem? Where do I start?
> I can send the php if required.
>
>
> Thanks
> John Funk
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list