JPDenni,
I have been able to find records with empty fields in an external script I use to generate metadata on my database. Here is the relevant part of the code:
Code:
$count = 0;
open (DB, '/default.db') or die "Nope: $!";
while (<DB> ) {
next if /^\s*$/;
next if /^#/;
next if /^guest/;
chomp;
@data = split (/\|/, $_, $#db_cols);
@dates = ($data[9], $data[10], $data[14], $data[18]);
if ($data[14] and $data[18]) {;}
else { print "Dates: @dates\n";
$count++;
}
}
close DB;
This code opens the database and puts the data from fields 9, 10, 14, and 18 in an array. Then if data exists in 14 and 18 it does nothing. If there is no data in 14 and 18 it prints out the array. Obviously I could do this better with a not statement, but I just wanted to show you my idea.
Can I implement someting similar to this into the sub query routine of db.cgi?
I thought about making a character like a tilde represent a blank field search. Then if one enters a tilde into a search field form a subroutine would run similar to the one I described above.
Can you offer any more help?
Thanks,
Lauren