Thank you for your post.
I don't have a FileMaker Server 8 machine available, but this definitely works with FileMaker Server 10.
Does this only occur in one file? That is, if you create a similar script in a second file, does that work?
IF you continue to encounter difficulty, another option you may want to try is split the script into two parts. That is, the first script enters Find Mode and ends. Have a "Find" button in the Layout that executes the Find and performs the error checking. Does that make sense?
Thank you so much for your reply. We did break the script into 2, as you had suggested. But that hasn't fixed the problem. Other databases on the same server have similar scripts that work just fine. The problem happens only for web users.
I've even created a new, test, database with a similar script and it also works for the web. We are beginning to suspect that the author of this database had initially worked in Filemaker8, but then saved a fewchanges to the database with a Filemaker 10 client. And then the application was copied to our Filemaker8 Server. And that's when the problems began.
At present, we are working to migrate our old Filemaker6 server to a Filemaker 10 server. We'll then move this database from the Filemaker 8 Server to the Filemaker 10 Server. That's the plan.....
Simply making changes to the file with filemaker 10 shouldn't break things for your version unless those changes incorporated a feature from Filemaker 10 that doesn't exist in your version. That's certainly not the case with the sample script you posted.
On the other hand, it's possible you have some file corruption here. I'd recover the file and test the recovered copy (even if it says "no problems found".) to see if behaves differently. If that fixes things, find an undamaged backup and use it to replace your current copy.
Thanks for your reply, and I agree with what you say. However, we did recover the file, and tested that copy. We still got the 'Bad request. The server could not process your request due to a missing command.' message when running the script from the web (using Instant Web).
I'm following the reasoning used in thread 33167, on this forum, posted by Nancy IDM on Dec 7, 09. Her comment is what has made us accelerate our migration to the Filemaker 10 Server - which is something we should be doing anyway.....:-)
I'll post the results once we have the database running on the new server. This had better work. (Fingers crossed)
"...could not process your request due to a missing command."
OK, that message suggests that some FMP 10 specific command was added that's causing your problem. Sounds like you can continue to upgrade and/or find out what change was made (perhaps a custom function?) and get it changed to be compatible with your current version.