[FX.php List] Search FMSA8 by date?

[Dale Bengston]

Hi Kevin,

Hmmm, I don't think it's the url-encoding. Your query is passing the  
date in the format dd/mm/yyyy and by default FMSA is probably  
expecting it in the US format of dd/mm/yyyy. In which case, 20 would  
be an invalid month. Could this be a clue? I completely forget how  
you defeat this "feature" in FileMaker, or whether it's system-level.  
Anyone remember the way to do it?

Hope this helps,
Dale


On Dec 19, 2006, at 8:56 PM, Kevin Futter wrote:

> Hi all,
>
> 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?
>
> -- 
> Kevin Futter
> Webmaster, St. Bernard's College
> http://www.sbc.melb.catholic.edu.au/
>
>
>
> ------------------------------------------
> This e-mail and any attachments may be confidential.  You must not  
> disclose or use the information in this e-mail if you are not the  
> intended recipient.  If you have received this e-mail in error,  
> please notify us immediately and delete the e-mail and all copies.   
> The College does not guarantee that this e-mail is virus or error  
> free.  The attached files are provided and may only be used on the  
> basis that the user assumes all responsibility for any loss, damage  
> or consequence resulting directly or indirectly from the use of the  
> attached files, whether caused by the negligence of the sender or  
> not.  The content and opinions in this e-mail are not necessarily  
> those of the College.
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list