Gossamer Forum: Products: DBMan: Installation: Range search "=>" or "=<" in Search form

You would have to make a change to sub query in db.cgi.

You can try this, although I'm not sure it will do what you want.

In sub query, after

Code:
if ($in{$column}   =~ /^\>(.+)$/) { ($db_sort{$column} eq 'date') and (&date_to_unix($1) or return "Invalid date format: '$1'"); 
  push (@search_gt_fields, $i); $in{"$column-gt"} = $1; $i++; next; }

add

Code:
if ($in{$column}   =~ /^\=\>(.+)$/) {  
  push (@search_gt_fields, $i); $in{"$column-gt"} = --$1; $i++; next; }

and after

Code:
if ($in{$column}   =~ /^\<(.+)$/) { ($db_sort{$column} eq 'date') and (&date_to_unix($1) or return "Invalid date format: '$1'"); 
  push (@search_lt_fields, $i); $in{"$column-lt"} = $1; $i++; next; }

add

Code:
if ($in{$column}   =~ /^\=\<(.+)$/) {  
  push (@search_lt_fields, $i); $in{"$column-lt"} = ++$1; $i++; next; }

It might work.

------------------
JPD