datetime search problems

[astefl]

I have some javascript that validates my search criteria then sends the startdate, and enddate to a hidden date field. the problem I'm having is that when I submit my datetime the data is URL encoded and xataface will not perform a proper search. If I type the URL in manually, the search works fine. I am using Xataface v1.2.2, the field is a datetime field. Any Ideas would be appreciated.

Here is my javscript:

Code: Select all

      function submit_advSearch(){
      debugger;
         var startDate = advSearch.startdate.value;
         var endDate = advSearch.enddate.value;
         var call_datetime = '';
         var sdate;
         var edate;
         //validate startdate < enddate
         if(startDate != ''){
            sdate = new Date(startDate.replace("-","/"));
         }
         if(endDate !=''){
            edate = new Date(endDate.replace("-","/"));
         }
            
         if (startDate !='' && endDate != '' && sdate > edate){
            alert('Start Date must be earlier than End Date');
            return false;
         }
         //END: validate startdate < enddate
         
         //Build call_datetime
         if (startDate != ''){
            call_datetime = '>=' + startDate + '%2000:00:00';
         }
         if (startDate != '' && endDate != ''){
            call_datetime += '+AND+<=' + endDate + '%2023:59:59';
         }else if(startDate != '' && endDate == ''){
            call_datetime = '>=' + startDate;
         }else if(startDate == '' && endDate != ''){
            call_datetime = '<=' + endDate + '%2023:59:59';
         }
         document.advSearch.call_datetime.value = call_datetime;
         
         document.advSearch.submit();
      }


[shannah]

Let the browser do the encoding. If you encode, then it gets encoded twice. E.g. I saw that you have explicitly placed %20 in your fields. Just put a space - not %20.

Xataface works properly with URL encoding - but if you encode and then the browser encodes when submitting the form, then it's double encoded.

[astefl]

That fixed it. Thanks.

[astefl]

Okay I lied, it's only halfway working. The start date is working, but the end date is not. I got rid of the encoding. It is still encoding in the url when I hit the search, but the end date is not working. I have also tried removing the Time from the datetime stamp and that isn't working either. I put an Alert on the javascript to show the datefield and it showed:
>=2010-02-25 00:00:00+AND+<=2010-02-27 23:59:59
I also tried:
>=2010-02-25+AND+<=2010-02-27

The >= and <= were serialized when it was submitted, but changing them back in the URL doesn't seem to help.

[shannah]

To do range searches use .. . E.g.

Code: Select all

2010-02-25..2010-02-27


or

Code: Select all

2010-02-25 00:00:00..2010-02-27 23:59:59


[kevinwen]

I have the problem uploading large size of file. I figured out that MAX_FILE_SIZE is defined as same as upload_max_filesize in php.ini. What if i want to set the MAX_FILE_SIZE to a number less than upload_max_filesize? where in my application could I define this? Thanks.

[astefl]

To do range searches use .. . E.g.

Code: Select all

2010-02-25..2010-02-27


or

Code: Select all

2010-02-25 00:00:00..2010-02-27 23:59:59


It looks like that works if I type it into the URL I will try adding it through code.