Gossamer Forum
Home : Products : DBMan : Discussions :

Re: [astorprop] Error on search results page

Quote Reply
Re: [astorprop] Error on search results page In reply to
Thanks JP. Here are the individual sections as written in HTML.PL.


sub html_record {
# --------------------------------------------------------
# How a record will be displayed. This is used primarily in
# returning search results and how it is formatted. The record to
# be displayed will be in the %rec hash.
my (%rec) = @_;
$rec{$db_key} =~ s/<?.B>//g;

1 while $rec{'ListPrice'} =~ s/(\d)(\d{3})\b/$1,$2/; $rec{'ListPrice'} = "\$" . $rec{'ListPrice'};
# Load any defaults to put in the VALUE field.
($db_auto_generate and print &build_html_record(%rec) and return);

my $font_color = 'Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399';
my $font = 'Font face="Verdana, Arial, Helvetica" Size=2';

print qq|
<TABLE WIDTH=751 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">
<TR>
<TD width="30" background="http://www.morrocco.com/images/1_left_1.gif" style="background-position:right; background-repeat:repeat-y">
</TD>
<TD align="left" valign="top" width="721">
<table cellpadding="0" cellspacing="0">
<tr><td>
<table cellpadding="0" cellspacing="0"><tr>
<td align="left" valign="top" width="172" bgcolor="#FFFFFF">
<div style="padding-top:0px "></div>
<div style="padding-top:0px ">
<table cellpadding="0" cellspacing="0" height="100%" >
<tr>
<td align="left" valign="top" width="172" background="http://www.morrocco.com/images/1_ft_1.gif" style="background-position:top; background-repeat:repeat-y">
<div style="padding-top:20px; padding-left:37px; padding-right:4px; line-height:13px; color:#48321E " class="style9">
</div>
</td>
</td>
</tr>
</table>
</div>
</td>
<td align="left" valign="top" width="549" height="100%" bgcolor="#FFFFFF">
<div style="padding-top:0px ">
<table cellpadding="0" cellspacing="0" height="100%">
<tr>
<td align="left" valign="top" width="549" height="100%" background="http://www.morrocco.com/images/8_fon_2.gif" style="background-position:top; background-repeat:repeat-y ">
<div style="padding-top:22px; padding-left:28px; padding-right:40px; line-height:13px; color:#48321E " class="style9">
<div align="left">
<table border="0" cellpadding="2" width="478">
<tr>
<td class="style9" width="98" valign="top"><b><font color="#000080">#$rec{'MLS'}</font></b></td>
<td class="style9" width="222"><b><font color="#000080">$rec{'Address'}</font></b></td>
<td class="style9" width="132"><b><font color="#000080">$rec{'ListPrice'}</font></b></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"></td>
<td class="style9" width="222"></td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Style</font></td>
<td class="style9" width="222">$rec{'Style'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Type</font></td>
<td class="style9" width="222">$rec{'Type'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Neighborhood</font></td>
<td class="style9" width="222">$rec{'AdvertisedSubdivision'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Description</font></td>
<td class="style9" width="222">$rec{'InternetRemarks'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Bedrooms</font></td>
<td class="style9" width="222">$rec{'Bedrooms'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Bathrooms</font></td>
<td class="style9" width="222">$rec{'BathsAll'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Fireplace(s)</font></td>
<td class="style9" width="222">$rec{'Fireplaces'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Parking</font></td>
<td class="style9" width="222">$rec{'Parking'}</td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"><font color="#6666FF">Picture</font></td>
<td class="style9" width="222"><A HREF="javascript:Start('$rec{'ListPictureURL'}')"><font color="#0000FF">Click Here</A></td>
<td class="style9" width="132"></td>
</tr>
<tr>
<td class="style9" width="98" valign="top"></td>
<td class="style9" width="222"></td>
<td class="style9" width="132"></td>
</tr>
</table>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="476">
<tr>
<td width="474"><a href="http://www.morrocco.com/mortgage/index.html"><img border="0" src="http://www.morrocco.com/.../pre-qualify.jpg.gif" width="110" height="17"></a>&nbsp;&nbsp;
<a href="$db_script_link_url&$db_key=$rec{$db_key}&view_records_two=1"><img border="0" src="http://www.morrocco.com/images/print-card.gif" width="105" height="16"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href="javascript:Start('$db_script_link_url&amp;$db_key=$rec{$db_key}&amp;forward_email_form=1')"><img border="0" src="http://www.morrocco.com/...schedule-showing.gif" width="142" height="14"><br>
<br>
</a></td>
</tr>
</table>
</center>
</div>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr></table></td></tr>
</TABLE>

|;
}


-------------------------------------

sub html_footer {
# --------------------------------------------------------
# Print the menu and the footer and logo. It would be nice if you left
# the logo in. ;)
#
# We only print options that the user have permissions for.
#
print qq!
<TABLE WIDTH=751 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">

<TD align="left" valign="top" width="721">
<table cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="middle" width="721" height="30" background="http://www.morrocco.com/images/1_down.gif" style=" background-position:left; background-repeat:no-repeat ">
<p align="center">
<a href="http://www.astor-properties.com/secured"><$font face="Arial" size="2" color="FFFFFF">New Search</a> | More Homes: $db_next_hits
</td>
</tr>
<tr>
<td align="left" valign="middle" width="721" height="42" background="http://www.morrocco.com/images/1_fon_d.gif" style="background-position:left; background-repeat:no-repeat ">
<div style="padding-left:59px; padding-top:0px ">
<table cellpadding="0" cellspacing="0" width="460">
<tr>
<td align="left" valign="top" width="166"><div style="padding-top:12px "><span class="style11">Astor
Properties, Inc. &copy; 2005</span></div></td>
<td align="left" valign="middle" width="11"><img src="http://www.morrocco.com/images/1_peret.gif" width="1" height="42"></td>
<td align="left" valign="top" width="105">
<div style="padding-left:16px; padding-top:7px ">
<span class="style6"><a href="http://www.morrocco.com/index-7.html" style=" color:#4B4B4B ">Privacy Policy</a></span>
</div>
</td>
<td align="left" valign="middle" width="17"><img src="http://www.morrocco.com/images/1_peret.gif" width="1" height="42"></td>
<td align="left" valign="top" width="151">
<div style="padding-left:16px; padding-top:7px ">
<span class="style6"><a href="http://www.morrocco.com/terms.html" style=" color:#4B4B4B ">Terms of use</a></span>
</TABLE>
</BODY>
</HTML>
!;
}

--------------------------------------------------------

sub html_view_success {
# --------------------------------------------------------
# This page displays the results of a successful search.
# You can use the following variables when displaying your
# results:
#
# $numhits - the number of hits in this batch of results.
# $maxhits - the max number of hits displayed.
# $db_total_hits - the total number of hits.
# $db_next_hits - html for displaying the next set of results.
#

my (@hits) = @_;
my ($numhits) = ($#hits+1) / ($#db_cols+1);
my ($maxhits); $in{'mh'} ? ($maxhits = $in{'mh'}) : ($maxhits = $db_max_hits);

&html_print_headers;
print qq|
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.0//EN">
<meta http-equiv="Content-Language" content="en-us">
<script language="JavaScript"> function Start(page) {
OpenWin = this.open(page, "information", "toolbar=no,menubar=no,location=no,scrollbars=no,resize=yes,HEIGHT=300,WIDTH=405");
}
</script>
<TITLE>Search Results</TITLE>
<style type="text/css">
<!--
.style3 {
color: #006BBA;
font-size: 11px;
font-family: Arial, Helvetica, sans-serif;
}
.style5 {
color: #075776;
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
font-size: 12px;
}
.style6 {
color: #4B4B4B;
font-size: 11px;
font-family: Arial, Helvetica, sans-serif;
}
.style9 {
font-size: 11px;
font-family: Arial, Helvetica, sans-serif;
color: #000000;
}
.style11 {color: #4B4B4B; font-size: 11px; font-family: Arial, Helvetica, sans-serif; font-weight: bold; }
.style13 {color: #48321E; font-size: 11px; font-family: Arial, Helvetica, sans-serif; }
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
</style>
</head>
<BODY BGCOLOR=#FFFFFF background="http://www.morrocco.com/images/1_fon.gif" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFF00">
<div align="center">
<center>
<table border="0" cellpadding="2" cellspacing="0">
<tr>
<TD width="1" background="http://www.morrocco.com/images/1_left_1.gif" style="background-repeat: repeat-y; background-position: right 50%">
&nbsp;
</TD>
<TD align="left" valign="top" width="741">
<table cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top" width="721" height="90"><img src="http://www.morrocco.com/images/1_top.gif" width="721" height="90"></td>
</tr>
<tr><td>
<table cellpadding="0" cellspacing="0" width="722"><tr>
<td align="left" valign="top" width="186">
<div style="padding-top:0px "><table cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top" width="19" height="157"><img src="http://www.morrocco.com/images/1_left.gif" width="19" height="157"></td>
<td align="left" valign="top" width="153"><div style="padding-top:0px ">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/...cab#version=6,0,29,0" width="153" height="157">
<param name="_cx" value="4048">
<param name="_cy" value="4154">
<param name="FlashVars" value>
<param name="Movie" value="http://www.morrocco.com/flash/button%20menu.swf">
<param name="Src" value="http://www.morrocco.com/flash/button%20menu.swf">
<param name="WMode" value="Window">
<param name="Play" value="-1">
<param name="Loop" value="-1">
<param name="Quality" value="High">
<param name="SAlign" value>
<param name="Menu" value="-1">
<param name="Base" value>
<param name="AllowScriptAccess" value="always">
<param name="Scale" value="ShowAll">
<param name="DeviceFont" value="0">
<param name="EmbedMovie" value="0">
<param name="BGColor" value>
<param name="SWRemote" value>
<param name="MovieData" value>
<param name="SeamlessTabbing" value="1"><embed src="http://www.morrocco.com/flash/button%20menu.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="153" height="157">
</object>
</div>
</td>
</tr>
</table></div>
</td>
<td align="left" valign="top" width="549" height="100%">
<div style="padding-top:0px "><img src="http://www.morrocco.com/images/1_top_1.gif" width="549" height="31"></div>
<div style="padding-top:0px ">
<table cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top" width="236" bgcolor="#E0E0D3"><div style="padding-top:11px; padding-left:10px; padding-right:0px; line-height:11px ">
<span class="style5"><strong>Search Results</strong></span><br>
<span class="style13">Your search returned <b>$db_total_hits </b>homes.</span></div>
</td>
<td align="left" valign="top" width="3"><img src="http://www.morrocco.com/images/8_right.gif" width="313" height="74"></td>
</tr>
</table>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="http://www.morrocco.com/images/8_top_123.gif" width="549" height="48">
</td>
</tr>
</table>
</div>
</div>
</td>
<blockquote>
</tr>
<tr>
<td></td>
</tr>
</table>
</center>
</div>
</body>
</table>
</html>

-------------------------------------------

What's puzzling me, is how on the SAME version of either IE or NETSCAPE this page output is FINE. Yet, on other computers, running the same browser and edition, you get simply a BLANK WHITE PAGE.

Any help is greatly appreciated.

Sincerely,
Dominic Morrocco
Subject Author Views Date
Thread Error on search results page astorprop 5551 Nov 17, 2005, 8:47 PM
Post Re: [astorprop] Error on search results page
JPDeni 5395 Nov 17, 2005, 10:18 PM
Thread Re: [astorprop] Error on search results page
astorprop 5425 Nov 18, 2005, 6:58 AM
Post Re: [astorprop] Error on search results page
JPDeni 5397 Nov 18, 2005, 7:20 AM