Is there a way to let dbman send an error message when someone tries to search for words with less than 2 letters or <space>.
Thx again.
Thx again.
Mar 6, 1999, 3:41 PM
Veteran / Moderator (8669 posts)
Mar 6, 1999, 3:41 PM
Post #2 of 2
Views: 1647
I don't think you'll have to worry about people searching for a space. I believe the script takes out leading and trailing spaces. But I could be wrong.
If you just wanted it to ignore any searches with only one letter, you could add this to sub query, before
if ($in{'keyword'}) { # If this is a keyword search, we are searching the same
if (($in{$column}) and (length($in{$column}) < 2)) {
$in{$column} = "";
}
}
If you want to send back an error message, you can use
if (($in{$column}) and (length($in{$column}) < 2)) {
return "Must have at least two letters in each search term";
}
}
I haven't tested this, but it seems like it would work.
------------------
JPD
If you just wanted it to ignore any searches with only one letter, you could add this to sub query, before
if ($in{'keyword'}) { # If this is a keyword search, we are searching the same
Code:
foreach $column (@db_cols) { if (($in{$column}) and (length($in{$column}) < 2)) {
$in{$column} = "";
}
}
If you want to send back an error message, you can use
Code:
foreach $column (@db_cols) { if (($in{$column}) and (length($in{$column}) < 2)) {
return "Must have at least two letters in each search term";
}
}
I haven't tested this, but it seems like it would work.
------------------
JPD