datetime search problems

A place for users and developers of the Xataface to discuss and receive support.

datetime search problems

Postby astefl » Tue Feb 09, 2010 6:30 pm

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();
      }
astefl
 
Posts: 5
Joined: Tue Feb 09, 2010 6:19 pm

Re: datetime search problems

Postby shannah » Tue Feb 09, 2010 6:59 pm

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.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: datetime search problems

Postby astefl » Thu Feb 11, 2010 10:28 am

That fixed it. Thanks.
astefl
 
Posts: 5
Joined: Tue Feb 09, 2010 6:19 pm

Re: datetime search problems

Postby astefl » Mon Mar 01, 2010 6:19 pm

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.
astefl
 
Posts: 5
Joined: Tue Feb 09, 2010 6:19 pm

Re: datetime search problems

Postby shannah » Mon Mar 01, 2010 6:42 pm

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
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: datetime search problems

Postby kevinwen » Wed Mar 03, 2010 5:55 pm

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.
kevinwen
 
Posts: 109
Joined: Mon Dec 28, 2009 3:44 pm

Re: datetime search problems

Postby astefl » Thu Mar 04, 2010 5:24 pm

shannah wrote: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.
astefl
 
Posts: 5
Joined: Tue Feb 09, 2010 6:19 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 39 guests

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved