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

[Gjermund Gusland Thorsen]

Thanks Steve, now I didn't have to :-p

Where is character 1496 in that string?

It would be easier to do %s/></>^M<

and reevaluate the XML document

ggt

2009/2/19, Steve Winter <steve at bluecrocodile.co.nz>:
> and as ggt will no doubt pop up to say, make sure everything is utf8 encoded
> ;-)
>
> Cheers
> Steve
>
>
> On 19 Feb 2009, at 15:53, Chris Hansen wrote:
>
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
> Steve Winter
> steve at bluecrocodile.co.nz
> m: +44 77 7852 4776
> 3 Calshot Court, Channel Way
> Ocean Village, Southampton SO14 3GR
>
> _______________________________________________
>  FX.php_List mailing list
>  FX.php_List at mail.iviking.org
>  http://www.iviking.org/mailman/listinfo/fx.php_list
>
>