[FX.php List] Solved? Anyone got a sober solution to a date range search?

[Tim 'Webko' Booth]

On 13/08/2008, at 3:32 AM, Gjermund Gusland Thorsen wrote:

> Well date searching works with mm/dd/ccyy, however when ...mm/dd/ 
> yyyy is added,
> the reply is error: 500 for both my FMSA installations 7.0 and 8.0v4r2

Interesting - I'vve not done a lot of date range searching but now  
have had a play...

If the date range is hard-coded in the php, it seems to be fine:

http://apachescricket.com/schedule_date.php

Will hard code for 01/01/2008...12/12/2008

Adding a parameter for the 1st date search:

http://apachescricket.com/schedule_date.php?date1=19/04/2008

and hard-coding the second also worked straight away

Adding the second parameter:

http://apachescricket.com/schedule_date.php?date1=04/19/2008&date2=10/19/2008

initially failed, but then I added urldecode and it was fine

<?php
	if  (isset($_REQUEST['date1'])){
		$date1 = urldecode($_REQUEST['date1']);
	} else {
		$date1 = "04/14/2008";
	}
	if  (isset($_REQUEST['date2'])){
		$date2 = urldecode($_REQUEST['date2']);
	} else {
		$date2="12/12/2008";
	}
	$dateSearch = $date1."...".$date2;
	echo "Search= ".$dateSearch;
	//Find matches
	$matchObj=new FX($dbHost,$port,$dbType,$conType);
	$matchObj -> setDBPassword($dbPass,$dbUser);
	$matchObj -> setDBData($dbName,'MATCH', 'all');
	$matchObj -> AddDBParam('Week1', $dateSearch , 'eq');
//	$matchObj -> AddDBParam('Grade', $grade , 'eq');
	$matchObj -> AddDBParam('Innings', "1" , 'eq');
	$matchObj -> AddSortParam('_kp_MatchNumber', 'ascend');
	$matchData = $matchObj -> FMFind();
?>