Hey, all. I'm stumped on this one. I have quite a few databases working alright, but this one just has be stumped. Here's the error message I'm getting.

CGI ERROR
==========================================
Error Message : Error loading required libraries.
Check that they exist, permissions are set correctly and that they compile.
Reason: syntax error at ./agentshtml.pl line 871, near "/font>

So, ok... I'm accustomed to getting little errors when I first upload the database. Problem is that I've looked and looked around line 871 and can't see a thing wrong with it. So any suggestions would be hot. Here's the link to my html.pl file in txt form:

http://www.fracturedatlas.org/agentshtml_pl.txt

And here is the "offending line" and a few lines surrounding it (I added line numbers for this posting):

855: print qq|
856: <table width=100%>
857: <tr><td width=50%>$previous</td>
858: <td width=50% align=right>$next</td></tr>
859: <tr><td colspan=2 align=center>$list</td></tr>
860: <tr><td colspan=2 align=center><$font>Record $nh of $db_total_hits</font></table>
861: |;
862: }
863:
864: # Below is where you define your form.
865:
866: # <-- Start of record display -->
867:
868: my $font_color = 'Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399';
869:
870:
871: print qq|
872:
873: <table width="650" border="0" cellspacing="1" cellpadding="2">
874: <tr>
875: <td width="150"> </td>
876: <td>
877: <p><font face="Verdana, Arial, Helvetica, sans-serif"><b>Agency Listing
878: - $rec{'Name'}</b></font></p>
879: <table width="400" border="0" cellspacing="1" cellpadding="2">
880: <tr valign="top">
881: <td width="74" bgcolor="#000000"><font 882: color="#FFFFFF"><b><$font>Address:</font></b></font></td>
883: <td width="313" bgcolor="#F3F3F3"><$font>$rec{'Address1'}

884: $rec{'Address2'}

885: <$font>$rec{'City'}, $rec{'State'} $rec{'Zip'</font></td>
886: </tr>

Any help would be grand. Many many thanks in advance, y'all!

lucid

You have a missing bracket here but I don't think that would cause the error.....

<$font>$rec{'City'}, $rec{'State'} $rec{'Zip'}</font></td>


Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Hehehehehehe... Yep, that was the whole problem. I'll be eating my hat in the corner if you need me. Thanks, Paul. You rock again.

-lucid

You might want to also note that in this line:

860: <tr><td colspan=2 align=center><$font>Record $nh of $db_total_hits</font></table>

you are ending a table without first ending the cells, as you are missing </TD></TR> before the closing table tag.


Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/