kfutter Posted December 20, 2006 Posted December 20, 2006 I've come across a snag getting some newly converted files to work as previously with FX. I've got a calendar database that a couple of different pages query by date, but I'm now getting error 500 back from FileMaker ("Date value does not meet validation entry options"). The relevant part of the query string causing the problem looks like this: [...] date.op=gte&date=20%2F12%2F2006&-find As you can see, FM seems to be choking on the URL-encoded version of the date. It worked fine in v6, but v8 seems much more strict with things like this (which by itself is no bad thing). Does anybody know how to get around this problem? Cheers, Kevin
kfutter Posted December 20, 2006 Author Posted December 20, 2006 Apologies for replying to my own post, but it turns out that it isn't the URL encoding causing the problem after all. Rather, it was the fact that I was using dd/mm/yyyy format, rather than mm/dd/yyyy format. Having swapped it around, it now works perfectly. This is obviously another difference between v6 & v8 - anybody know if this is a setting that can be changed?
kfutter Posted January 17, 2007 Author Posted January 17, 2007 Replying to myself yet again : It seems that our server may have been incorrectly set up with the wrong date system, which would explain the problem above. Still looking in to that one, but it appears not to be a FileMaker issue after all.
Recommended Posts
This topic is 6589 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now