AppleScript causing FMP XML output errors

[RIRedinPA]

Hi all:

I have an AppleScript that pulls data from a Canto Cumulus db and transfers it to a FMP 6.0 db. I am then using PHP and a class called FX to query the FMP db and display the results through a web browsers. (FX queries the FMP db, gets the results and parses the XML and then returns it to PHP in a multidimensional array - very cool). When I query a hand coded db it works fine, when I query a db that was created with AppleScript I get an XML error - invalid token.

I don't think it is the db per say because I took the one that was giving me the error, purged it off all records created by AppleScript, added a new record, queried it from my web page and it worked fine.

My Mac Tech guy thought it might have to do with AS not properly closing the db file - you know how when you write to a file using AS you also have to close that file. Any help would be appreciated.

Thanks

[cjaeger]

I believe this being rather a problem with invisible characters in the data.

btw, how do you create a db with applescript?