AnsweredAssumed Answered

CWP - Getting error 500 on timestamp .op=bw

Question asked by user10272 on Dec 20, 2012
Latest reply on Dec 20, 2012 by user10272

Hello,

 

I've run into a problem after converting a solution from FileMaker 11 to 12.

It is a calendar module that has a CWP frontend, which worked fine under FMS 11, but is having some problems under FMS 12.

 

The FileMaker solution has been converted from .fp7 to .fmp12 via FileMaker Advanced, and everything is working fine in FileMaker.

 

Some of my cwp-queries doesn't work though.

The problem is timestamp fields that I want to query with a range like:

 

http://[myhost]/fmi/xml/fmresultset.xml?-db=cwp&-lay=__CAITd_selector&item_Start_ts=11/26/2012...1/6/2013&item_Start_ts.op=bw&item_id_rsrc=82&-find

(item_Start_ts is a timestamp field).

 

This works fine in FMS 11, but on FMS 12 i get ERRORCODE: 500 (Date value does not meet validation entry options).

 

Changing it a bit:

http://[myhost]/fmi/xml/fmresultset.xml?-db=cwp&-lay=__CAITd_selector&item_Start_ts=11/26/2012&item_id_rsrc=82&-find

Works fine on 12 too.

 

Even this:

http://[myhost]/fmi/xml/fmresultset.xml?-db=cwp&-lay=__CAITd_selector&item_Start_ts=11/26/2012&item_Start_ts.op=gt&item_id_rsrc=82&-find

...works on 12.

 

Anyone seen this, and perhaps got a solution?

 

Kind regards,

Johan

Outcomes