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

[Gjermund Gusland Thorsen]

1496 is the last character I would search for ugly chars

ggt

2009/2/19, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
> 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
>  >
>  >
>