Gossamer Forum
Home : Products : DBMan : Customization :

I will ask again, closing the gap between records

Quote Reply
I will ask again, closing the gap between records
I have set up a database for a local foodbank, and now I need to print all entries, the problem is, the space between records is too large(all records display on one line), I only get 27 entries per page, but I need this to be around 50 per. I have looked at other threads, but have found nothing. Is there a way to make that break space smaller??????????
Any help would be appreciated, I need this printed for Sunday!!!!

Pat Drake
a.k.a. Patio Lanterns
Quote Reply
Re: I will ask again, closing the gap between records In reply to
on sub html_record

Code:
print "$rec{'A'}" if ($rec{'A'});
print "$rec{'B'}" if ($rec{'B'});
print "$rec{'C'}" if ($rec{'C'});
and so on...

__________________________
http://anteromas.com
Trading Resources
Quote Reply
Re: I will ask again, closing the gap between records In reply to
Not sure I follow you, this is my sub html_record

print qq|

<font size="1">ID</font><font size="3"><strong>$rec{'ID'}</strong></font>
<font size="1">Name</font><font size="3"><strong>$rec{'Name_Last'}
$rec{'Name_First'}</strong></font><font size="1">File</font><font size="3"><strong>$rec{'Drug'}</strong></font><font size="1">Add</font><font size="3"><strong>$rec{'Address'}</strong></font>
<font size="1">Ph</font><font size="3"><strong>$rec{'Phone'}</strong>
<font size="1">Family#<strong><font size="3">$rec{'Category'}</strong>
<font size="1">Boys<strong><font size="3">$rec{'B_Ages'}</strong><font size="1">Girls<strong><font size="3">$rec{'G_ages'}</strong>

|;
}
My problem is, between say record 1 & record 2, there is about a 1/4" space between them on the display(and print), is there a way to close the gap to say 1/8"? I get 27 records per page right now, but I need at least 50 per page?

Pat Drake
a.k.a. Patio Lanterns
Quote Reply
Re: I will ask again, closing the gap between records In reply to
Clarification:
it displays like this
Name 1 File # 1 Address #1

Name 2 File # 2 Address #2
I need the space between Name 1 and name 2 reduced to allow more records to show(print)on 1 page!
I hope this better explains it.
And thanks for the help!

Pat Drake
a.k.a. Patio Lanterns
Quote Reply
Re: I will ask again, closing the gap between records In reply to
Hi Pat, I'm not certain if this will be of help or not but, it sure won't hurt to try closing the gaps (blank spaces) around the print statements.

THIS:
print qq|

<font size="1">ID</font><font size="3"><strong>$rec{'ID'}</strong></font>

BECOMES:
print qq|<font size="1">ID</font><font size="3"><strong>$rec{'ID'}</strong></font>

- - -
THIS:
<font size="1">Boys<strong><font size="3">$rec{'B_Ages'}</strong><font size="1">Girls<strong><font size="3">$rec{'G_ages'}</strong>

|;
}

BECOMES:
<font size="1">Boys<strong><font size="3">$rec{'B_Ages'}</strong><font size="1">Girls<strong><font size="3">$rec{'G_ages'}</strong>|;
}

Give that a try and see if it helps in removing the unwanted blank lines.

Quote Reply
Re: I will ask again, closing the gap between records In reply to
I think Karen is right.

Try to eliminate the gap by moving|; next to {'G_ages'}</strong>

and see what happen.


__________________________
http://anteromas.com
Trading Resources
Quote Reply
Re: I will ask again, closing the gap between records In reply to
It looked good in theory, but, it did not work.
I've been looking at the db.cgi and the default.cfg, but I can't see anywhere to try to close the gap.
Thanks for your help Santana & Karen.
I'm gonna keep plugging away at it, I may get it through trial and error.

Pat Drake
a.k.a. Patio Lanterns
Quote Reply
Re: I will ask again, closing the gap between records In reply to
Hi Pat, in html.pl, locate the following code and replace the paragraph tag with a linebreak tag. Found in sub html_view_success {

# Go through each hit and convert the array to hash and send to
# html_record for printing.
for (0 .. $numhits - 1) {
print "<P>";

BECOMES:

# Go through each hit and convert the array to hash and send to
# html_record for printing.
for (0 .. $numhits - 1) {
print "<BR>";


Quote Reply
A Success!!!!! In reply to
Thanks Karen, it worked perfect.
and before the deadline as well, you rock my world!!!!
Also, thanks to Santana as well.

Pat Drake
a.k.a. Patio Lanterns