Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Only getting first record pictures from xml requests.

Featured Replies

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 by Guest

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.

  • Author

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

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.