Good catch! I know why it didn't work. I just didn't think about it before.
Now take the code I posted before to convert the military time into regular time and put it in a subroutine:
sub convert_time {
my ($time) = $_[0];
insert the code from above
return $output;
}
In sub html_record, after
my (%rec) = @_;
add
for ($conv=9; $conv<=36; ++$conv) {
$rec{$db_cols[$conv]} = &convert_time($rec{$db_cols[$conv]};
}
That should convert all your times into the format you want.
Then we get to start working on the search.
Can you give me a ballpark figure of how many records might be returned in a search for offices and hotlines that are currently open in a city? Let's say the search was done at noon on a Wednesday, when most things would be open. What would be the most that would be returned?
JPD
http://www.jpdeni.com/dbman/
Now take the code I posted before to convert the military time into regular time and put it in a subroutine:
Code:
sub convert_time {
my ($time) = $_[0];
insert the code from above
return $output;
}
my (%rec) = @_;
add
Code:
for ($conv=9; $conv<=36; ++$conv) {
$rec{$db_cols[$conv]} = &convert_time($rec{$db_cols[$conv]};
}
Then we get to start working on the search.
Can you give me a ballpark figure of how many records might be returned in a search for offices and hotlines that are currently open in a city? Let's say the search was done at noon on a Wednesday, when most things would be open. What would be the most that would be returned?
JPD
http://www.jpdeni.com/dbman/