to save space in my database i set up the yes/no questions to = 1 (for yes) or 0 (for no) how do get dbman to write out "yes" for 1 and "no" for a 0
Oct 13, 2001, 4:04 PM
Enthusiast (606 posts)
Oct 13, 2001, 4:04 PM
Post #2 of 7
Views: 1850
You mean you have a field in your database which contains "1" for "yes" and "0" for "no" and want dbman to print out "yes"/"no" in search results?
Then you could add to the beginning of html_record, after the line "my %rec = @_":
$rec{'field_name'} =~ s/1/yes/;
$rec{'field_name'} =~ s/0/no/;
....
print "$rec{'field_name'}";
With "field_name" being the name of the field that holds "1" or "0".
kellner
Then you could add to the beginning of html_record, after the line "my %rec = @_":
$rec{'field_name'} =~ s/1/yes/;
$rec{'field_name'} =~ s/0/no/;
....
print "$rec{'field_name'}";
With "field_name" being the name of the field that holds "1" or "0".
kellner