You can make a little adjustment to db.cgi that will allow you to search for month names.
Look for
sub query.
Scroll down a little bit until you see lines that start like this:
Code:
else {
$i = 0;
foreach $column (@db_cols) {
if ($in{$column} =~ /^\>(.+)$/) { ...
push (@search_gt_fields, $i);...
if ($in{$column} =~ /^\<(.+)$/) { ...
push (@search_lt_fields, $i);...
if ($in{$column} !~ /^\s*$/) {...
push(@search_fields, $i); $i++; next; }
if ($in{"$column-gt"} !~ /^\s*$/) { ...
push(@search_gt_fields, $i); }
if ($in{"$column-lt"} !~ /^\s*$/) {...
push(@search_lt_fields, $i); }
$i++;
}
}
(This is just the beginnings of the lines so you can orient yourself.)
In the third "if" statement, the one that starts with
Code:
if ($in{$column} !~ /^\s*$/) {
delete the following part -- just from this one, though!
Code:
($db_sort{$column} eq 'date') and (&date_to_unix($in{$column}) or return "Invalid date format: '$in{$column}'");
The line will end up looking like this:
Code:
if ($in{$column} !~ /^\s*$/) {
push(@search_fields, $i); $i++; next; }
Then you'll be able to enter "Jun" and get all the records that were added in June.
------------------
JPD
