My clients upload photos to my server through the FileMaker database. Actually, this is not really correct. They place an order through the FileMaker database on the web. After the order is placed, they are then taken to another cgi page where they can then upload the photo (If they could upload photos through FM then I would not have the following problem). Unfortunately this process takes them out of the FileMaker database. If the client then wants to place another order and upload a photo, they have to sign in to the database again. I have tried cookies in the past that would allow them to click a button that takes them back to their home page, but if the client has cookies turned off, they are still able to place an order, but the problem on my end is I don't know who the order is coming from (all clients have to sign in with a user name and password). I was tried having a separate window open with the upload form, but learned that the clients information is not carried over to the upload form.

Any thoughts or solutions to this problem will be greatly appreciated.

Thanks - Sam

"Unfortunately this process takes them out of the FileMaker database."

It need not do that. Serve the image through FMP without storing the image in FMP.

There is a Sample File about that.

Hi, Sam! I'm not familiar w/mixing cgi-s but maybe you continue to pass tokens through your solution and/or use inlines to keep the FMP sessions going? Or maybe change a field to preserve their "state" as being logged in or not? As to your cookies, maybe you can require them at all times so the site does not work with cookies disabled. I personally am annoyed by cookie-requiring sites (except this fabulous FMFORUMS of course!), but they are common enough.

Just out of curiousity, what cgi- are using for file uploads?

Like Steve said, you should be able to pass the login values along through the cgi and back to FM. You may need to look at the html "onload()" function ot a META Refresh in the process.

With PHP, I have been able to upload files, update the database and call a Format file. All from the one PHP script.

All the best.

Garry