Only getting first record pictures from xml requests.

[rshacklett]

I am having problems getting Filemaker to serve up the correct photo when being pulled an xml request thru XSLT. In a nutshell, its always serving up the photo from the first record of a found set - no matter what recid I call for.

I believe that the url request is correct. Here's 2 examples:

1) Below is the url for the image src that is being generated. (I added the domain info to all so you can click & see)

http://www.adlineagency.com/fmi/xsl/cnt/data.jpg?-db=6255%20Site%20Database&-lay=NewsListPage&-recid=28&-field=Photo1(1)

My request is asking for a photo from record 28 - which should be a photo of a building entrance - but instead I'm receiving a photo I placed on the first record (recid 1) of the table (a helicopter pic).

Viewing from the layout inside Filemaker its showing the correct photo, and if I search on recid 28 (I setup a field that allows me to serach by recid) - it gives me the correct photo inside Filemaker. I made sure the -lay is matching to the correct layout, and that field is placed on the layout.

2) Take a look at the home page: I put a different picture on the two sections - News & Games (you'll have to scroll down to see the second one) but its giving me back the same photo for each record.

http://www.adlineagency.com/fmi/xsl/6255_wrhs_basketball/template.xsl?-db=6255%20Site%20Database&SchoolDiv=WRHS%20Basketball&Layoutname=HomePage&-sortfield.1=Sortorder&-find&-grammar=fmresultset&-lay=HomePage&-token.1=WRHS%20Basketball&-token.2=HomePage

I don't believe the problem is with the XSLT -- I think its something with how FM is finding the photo internally & something to do with what I have setup on my layout.

Any ideas?

Running FM Advanced Server 7 on Mac OS X 10.3.9.

Thanks!

Ryan Shacklett

Edited December 30, 2005 by Guest

[Martin Brändle]

Seems to be a bug of the WPE. Did you update to the newest WPE? When I do a

http://www.adlineagency.com/fmi/xml/fmresultset.xml?-db=6255%20Site%20Database&-lay=NewsListPage&-findall

I see that in the XML result tree the WPE is 7v03. However, with the newest updater (FMSA 7v3), the WPE version should be 7v05.

BTW: Never turn on fmxml extended privilege set without any account/password. The whole database could be read out, as you see.

[rshacklett]

You were right! I initally downloaded and installed the Server updates, but didn't see the one for the Web Engine!

That fixed the problem! Thanks so much for your time!

Also - thanks for the note on security. I just opened it up so everyone could look at everything.

It also fixed another problem of the site's occasionally giving me "unknown errors".

Thanks!

Ryan