Feature Request

Firstly, great work.

A useful addition to this class would be the ability to incorporate ranges into the BuildSQLWhereClause...

From what I can see, the current build where clause will only work with exact matches
(WHERE 'queryDate' = 2008-04-15)
and not ranges
(WHERE 'queryDate' BETWEEN $startDate AND $endDate)
or
(WHERE 'queryDate' >= $startDate)
or
(WHERE 'queryDate' <= $endDate)

as an interim, the below code will allow for the same result to be achieved...
(for those wondering how to get around it)

if(($startDate != NULL)&&($endDate != NULL)) {
$where[] = "'queryDate' >= $startDate AND 'queryDate' <= $endDate";
} elseif (($startDate != NULL)&&($endDate == NULL)) {
$where[] = "'queryDate' >= $startDate";
} elseif (($startDate == NULL)&&($endDate != NULL)) {
$where[] = "'queryDate' <= $endDate";
} else {
$where[] = NULL;
};

if(($startDate != NULL)&&($endDate != NULL)) {
$where[] = "'queryDate' BETWEEN $startDate AND $endDate";
} elseif (($startDate != NULL)&&($endDate == NULL)) {
$where[] = "'queryDate' >= $startDate";
} elseif (($startDate == NULL)&&($endDate != NULL)) {
$where[] = "'queryDate' <= $endDate";
} else {
$where[] = NULL;
};