Update of /cvsroot/mantisbt/mantisbt/core
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv18811
Modified Files:
filter_api.php
Log Message:
Fix 7849: filters on custom date field causes SQL error
Index: filter_api.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/core/filter_api.php,v
retrieving revision 1.154
retrieving revision 1.155
diff -u -d -r1.154 -r1.155
--- filter_api.php 21 May 2007 06:34:10 -0000 1.154
+++ filter_api.php 27 May 2007 22:31:59 -0000 1.155
@@ -1102,11 +1102,11 @@
break ;
case CUSTOM_FIELD_DATE_AFTER:
array_push(
$t_join_clauses, $t_cf_join_clause );
- $t_custom_where_clause
= '(( ' . $t_table_name . '.value+0) > ' .
($t_filter['custom_fields'][$t_cfid][1]+1) . ')' ;
+ $t_custom_where_clause
= '( (' . $t_table_name . '.value+0) > ' .
($t_filter['custom_fields'][$t_cfid][1]+1) ;
break ;
default:
array_push(
$t_join_clauses, $t_cf_join_clause );
- $t_custom_where_clause
= '(( ' . $t_table_name . '.value+0) BETWEEN ' .
$t_filter['custom_fields'][$t_cfid][1] . ' AND ' .
$t_filter['custom_fields'][$t_cfid][2] . ')' ;
+ $t_custom_where_clause
= '( (' . $t_table_name . '.value+0) BETWEEN ' .
$t_filter['custom_fields'][$t_cfid][1] . ' AND ' .
$t_filter['custom_fields'][$t_cfid][2];
break ;
}
} else {
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
|
