I'm having a problem accessing images in my database using the urls included in a requested xml dump. For example, one of the supplied urls is: -

FMPro?-db=My Database&-RecID=45904&Pictures Database::Picture=&-img

----

If I prefix this with http://<servername> and enter it in a web browser I get the following: -

Data Entry Error:Your attempt to save changes to the current record failed because of the following:

Unknown error number 102

----

Does anyone know what might be the problem?

Ok, this will only work on yout Intranet, unless you buy a domain name for the server.

You will need to run an internal DNS server somewhere in your building. Once DNS is up and running you can basically feed any URL you want to your users.

Thanks for your reply. However in this case I am accessing the server over the intranet, and the dns etc is set correctly.

Another point is that I can access the images if I select them by image key. Eg:

http://<servername>/FMRes/FMPro?-db=PicturesDB&key=33208&-img

this works, and displays the image in a browser. However, I have no means of linking the key value to the RecordID or anything else. Does anyone know how this might be done?

It is better to serve images from a folder. Images in db = waste of db resourse imo.

Unable said:

It is better to serve images from a folder. Images in db = waste of db resourse imo.

You're probably right, but in this case these are large databases running off a FileMaker server which I didn't set up, so I haven't any choice.

"...error number 102"

You can find the problem indicated by 102 if you will look in FileMaker Help > Status (CurrentError) function.

"...so I haven't any choice"

I would suggest that attitude is your own self-imposed limitation. But then,

Unable said:

"...error number 102"

You can find the problem indicated by 102 if you will look in FileMaker Help > Status (CurrentError) function.

Yes, I should have mentioned already, the error suggests I'm referring to a field that does not exist - however in this case I'm not - I'm simply trying to access a URL that Filemaker gave me for the image.

"...so I haven't any choice"

I would suggest that attitude is your own self-imposed limitation. But then,

lol, not in this case unfortunately. The pictures database is long established, heavily related and widely used throughout my company. Reinventing it would be a waste of time & money.

I guess the URL is having problems with the Related field:

Pictures Database::Picture

You could create a Calculated field, which is simply "Pictures Database::Picture". This may work as the field which is called by the URL.

Good Luck.

Garry

There is an example of serving images in the Sample Files forum. I don't know if it will be of any use to you.

Good Luck

Thanks for your responses. I've tried the calculation field option and that doesn't work either.

In the end I've found a workaround. I've set up a picture field which grabs the image from the pictures db and stores it locally in the web shared db. Since the web shared db doesn't hold any data of its own, this is fine because we can instantly rebuild it if the pictures field gets out of date.