Hi,

I've been experiencing what seems to be erratic behavior using XML urls to get data from a FM database using FileMaker Server 8 Advanced.

While a url like this (formatted here for readability) returns some records:

http://account:[email protected]:80/fmi/xml/FMPXMLRESULT.xml.?

-db=database.fp7&

-lay=layout1&

fieldTwo=xyz&

-find

If I replace it with something like this below, it no longer finds any records, even though fieldOne is a text field containing 1, for every record in the database, and it's present on the layout, and it's also from the same table as the layout context table. (Also, I can see this field in the results of the above query, so I know it's there.)

http://account:[email protected]:80/fmi/xml/FMPXMLRESULT.xml.?

-db=database.fp7&

-lay=layout1&

fieldOne=1&

-find

The message I get is Error Code 401, which is "No records match this request".

Here's the weird thing. If I restart FileMaker Server, the problem goes away, and I get the expected results... at least for a while.

More details:

Everything is running on the same machine: WPE, FMServer, Browser.

FM Server version 8.0v2

WPE version: 8.0.1.28

I am using FM's Accounts and Privileges to restrict access to the table (which the layout is based on), though I don't see how that could be the problem.

Thanks,

Marek

Edited April 6, 200619 yr by Guest
I fixed a transcription error, by removing the dash before the field name.

Remove the - before the field name.

Martin,

Sorry. That was a transcription error while posting here. I've removed the dashes in the original post. In my test case, the syntax was correct.

-Marek

Hmm. Did you try to rebuild the index of this field? (Turn indexing off, then on again). Might be that something is wrong there (probably because at some time the database was opened with FM8v1).

Martin,

Thanks for the suggestion.

It didn't change anything.

For the record, I went into "Define Database", turned indexing off for "fieldOne" (unchecked "Automatically create indexes as needed", it was already set to "None"), got out of "Define Database", then back in, to change the indexing by checking "Automatically create indexes as needed".

I also restarted FM Server, before retrying and getting the same problem.

Marek

Try with the fmresultset.xml grammar, which is the recommended grammar for CWP, instead of FMPXMLRESULT.xml

Martin,

No luck. Same problem with fmresultset.xml.

By the way, I'm using FMPXMLRESULT.xml because that is the one used by FX.php, which I'm using.

Thanks,

Marek

Hmm. My ideas go out. Probably that's a case for an error report to FMI.

Did you try to rebuild the layout?

Martin,

I have passed this problem on to FileMaker support for investigation. They are looking into it, and I will report back when I hear an explanation, a solution, or a work around.

Thanks,

Marek

FYI: this problem was resolved in a later version of FM Server or the Web Publishing Engine.

I don't know which component contains the fix, but the problem was resolved by these versions (or possibly before)

FM Server version 8.0v4

WPE version: 8.0.4.36

-Marek