2 Replies Latest reply on Dec 20, 2012 5:11 AM by user10272

    CWP - Getting error 500 on timestamp .op=bw

    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

        • 1. Re: CWP - Getting error 500 on timestamp .op=bw
          steve.winter

          Random untested thought - those aren't actually valid Timestamps, a timestamp is m/d/Y H:i:s, so perhaps if you searched for

               …&item_Start_ts=11/26/2012%20::…1/6/2013%20::&…

          it might work…

           

          Cheers

          Steve

          • 2. Re: CWP - Getting error 500 on timestamp .op=bw
            user10272

            Hi Steve,

             

            thanks for the idea.

             

            I know they aren't really valid timestamps, but it worked fine with FMS 11, and you could also enter that in find mode in FMP.

            But the thought has occured to me too and I tried something similar to your suggestion before:

             

            ...&item_Start_ts=11/26/2012%2000:00:00...1/6/2013%2000:00:00&item_Start_ts.op=bw&...

            Then I get error 501 instead (Time value does not meet validation entry options).

            (Tried it both with double and single zeros)

             

            I also tried your exact suggestion just now:

            ...&item_Start_ts=11/26/2012%20::...1/6/2013%20::&item_Start_ts.op=bw&...

            Then I get error 508 (Invalid value entered in Find mode)

             

            The strange thing is that the exact same query as in my original post works perfectly fine under FMS 11.