Results Across Multiple Columns

Results Across Multiple Columns (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

styrochem -> Results Across Multiple Columns (8/17/2004 8:15:11)
Can anyone provide me some ideas or locations on how I can make my database results divided among multiple columns instead of just a long running list? I have an employee list that I want to list three different employees on each line rather than on seperate lines.

rdouglass -> RE: Results Across Multiple Columns (8/17/2004 10:12:59)
Here's the basics: http://www.outfront.net/spooky/advanced.htm#Formatting If you get stuck, there are several posts relating to this topic. Do a search and you should be able to find something relevant. Just change the 4 to a 3 (from the instructions above) and it should do what you want. I do something like that but with a twist. Normally the records will flow across the rows. I have a script where the info flows down the columns but still with 3 columns of info. A lot more work than the above but if you're interested, I'll post it. Hope it helps.

BeTheBall -> RE: Results Across Multiple Columns (8/17/2004 10:13:03)
http://www.outfront.net/spooky/advanced.htm#Formatting

styrochem -> RE: Results Across Multiple Columns (8/17/2004 12:39:48)
rdouglass....I would be interested in seeing your modified script for the columns.

rdouglass -> RE: Results Across Multiple Columns (8/17/2004 13:52:26)

Here is a very stripped down version of what I'm doing. The actual code I'm using color codes the names and stuff; it's part of an online checkin/checkout board. This code as I'm posting draws data from a DB based on the query's ORDER BY clause and dumps it into an array.

Then it checks to see how many rows it will need to make 3 columns (it checks for the last row not full and compensates) then builds a 3 column table with your data going down column 1 first then flowing to column 2 then to column 3.

There may be more elegant ways of doing it, but this works pretty good for me. You can make it write anything you wish in the cells - I do a combination of color coding, onMouseover JavaScripts, and hyperlinks all at the same time so you can be quite flexible.

To do much more than this simple list with my code, I'd suggest background with arrays.

<%
'the db connector and query will be different for your environment
myDSN = "DSN=EmeraldCity;uid=sa;pwd=;database=CAIntNet"
userSQL = "SELECT lastname FROM tblUsers ORDER BY lastname"
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
set rstemp=conntemp.execute(userSQL)

IF  rstemp.eof THEN 'check for empty recordset
   response.write ("ERROR 127:NO USERLISTQ1  " & userSQL)
	rstemp.close
	set rstemp=nothing
	conntemp.close
	set conntemp=nothing
   response.end
	
ELSE 'grab the data and put it in an array
	alldata=rstemp.getrows
	rstemp.close
	set rstemp=nothing
	conntemp.close
	set conntemp=nothing
END IF

'Next 3 IF..THEN's compensate if the last row is not full
IF ((ubound(alldata,2)+1) MOD 3) = 0 THEN
	rowFix = 0
	rowFix2 = 0
END IF
IF ((ubound(alldata,2)+1) MOD 3) = 1 THEN
	rowFix = 1
	rowFix2 = 1
END IF
IF ((ubound(alldata,2)+1) MOD 3) = 2 THEN
	rowFix = 1
	rowFix2 = 2
END IF

'figure how many FULL rows we need for 3 columns
thirdnumrecords=fix((ubound(alldata,2)+1)/3) 

'Start the table
response.write "<table border='0' cellpadding='0' cellspacing='0' width='450'>" & vbcrlf

'Loop thru all FULL rows
FOR rowcounter= 0 TO (thirdnumrecords-1)
   response.write "<tr><td width='150'>" & alldata(0,rowcounter)& "</td>" & vbcrlf
   response.write "<td width='150'>" & alldata(0,(rowcounter + thirdnumrecords + rowFix))& "</td>" & vbcrlf
   response.write "<td width='150'>" & alldata(0,(rowcounter + thirdnumrecords + thirdnumrecords + rowFix2)) & "</td></tr>" & vbcrlf
NEXT
	
'Next 2 IF..THEN's are for last row not full
IF rowFix2 = 1 THEN 
   response.write "<tr><td width='150'>"& alldata(0,rowcounter) & "</td>" & vbcrlf
	response.write "<td width='150' valign='top' align='left'> </td></tr>" & vbcrlf
	response.write "<td width='150' valign='top' align='left'> </td></tr>" & vbcrlf
END IF
IF rowFix2 = 2 THEN 
   response.write "<tr><td width='150'>" & alldata(0,rowcounter) & "</td>" & vbcrlf
   response.write "<td width='150'>" & alldata(0,(rowcounter + thirdnumrecords + rowFix))& "</td>" & vbcrlf
	response.write"<td width='150' valign='top' align='left'> </td></tr>"  & vbcrlf
END IF

'Finish the table
response.write "</table>" & vbcrlf
%>

Hope it helps...

styrochem -> RE: Results Across Multiple Columns (8/30/2004 7:48:24)

If I utilize the Formatting Output rows in the link provided above, how do I implement that into this document? I attempted to do so and it starting giving me an error so I think I did it incorrectly.

Here is the page code I need to alter

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Phone List</title>
</head>

<body bgproperties="fixed">

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="42%" style="border-style: none; border-width: medium" align="center">
    <p align="center"><font size="2"><img border="0" src="WinCup.gif" width="232" height="105"></font></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="158%" id="AutoNumber9" height="184" align="left">
      <tr>
        <td width="100%" height="19" align="center">
        <p align="left"><font color="#000080" size="2"><b>WinCup Plants - Click below</b></font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Stone Mountain</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Higginsville</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left">
        <p align="left"><font size="2">Shreveport</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left">
        <p align="left"><font size="2">El Campo</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Tolleson</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Mt. Sterling</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Corte Madera</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">West Chicago</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Metuchen</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Jacksonville</font></td>
      </tr>
      <tr>
        <td width="100%" height="15" align="left"><font size="2">Mooresville</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="42%" style="border-style: none; border-width: medium" align="center" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
     </td>
    <td width="28%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  </table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber8">
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber10">
      <tr>
        <td width="100%">
        <p align="center"><a name="Stone Mountain"><font size="2">Stone Mountain</font></a></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">4640 Lewis Rd</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Stone Mountain GA 30083</font></td>
      </tr>
      <tr>
        <td width="100%"> </td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Stone Mountain Extensions</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber11">
      <tr>
        <td width="100%"><font size="2">770.938.5281</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Fax 770.270.0510</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber12">
      <tr>
        <td width="100%"><font size="2">Plant Manager - Pat Collins</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Contact Person - Shonnia Houston</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <table>
      <thead>
        <tr>
          <td><b>name</b></td>
          <td><b>work_phone</b></td>
        </tr>
      </thead>
      <tbody>
        <!--webbot bot="DatabaseRegionStart" s-columnnames="emp_id,emp_login,emp_password,emp_level,name,title,email,work_phone,home_phone,cell_phone,address,dep_id,picture,manmonth,plant,company,department" s-columntypes="3,202,202,3,202,202,202,202,202,202,202,3,202,3,202,202,202" s-dataconnection="Employee" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="emps" s-displaycolumns="name,work_phone" s-criteria="[company] EQ [Wincup] + [plant] EQ [stonemountain] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company =  'Wincup' AND plant =  'stonemountain') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No employees listed." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr>" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM emps WHERE (company =  'Wincup' AND plant =  'stonemountain') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No employees listed.</td></tr>"
fp_sDataConn="Employee"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&emp_id=3&emp_login=202&emp_password=202&emp_level=3&name=202&title=202&email=202&work_phone=202&home_phone=202&cell_phone=202&address=202&dep_id=3&picture=202&manmonth=3&plant=202&company=202&department=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan --><tr>
          <td><font size="2">
          <!--webbot bot="DatabaseResultColumn" s-columnnames="emp_id,emp_login,emp_password,emp_level,name,title,email,work_phone,home_phone,cell_phone,address,dep_id,picture,manmonth,plant,company,department" s-column="name" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>name<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"name")%><!--webbot bot="DatabaseResultColumn" endspan --></font></td>
          <td><font size="2">
          <!--webbot bot="DatabaseResultColumn" s-columnnames="emp_id,emp_login,emp_password,emp_level,name,title,email,work_phone,home_phone,cell_phone,address,dep_id,picture,manmonth,plant,company,department" s-column="work_phone" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>work_phone<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"work_phone")%><!--webbot bot="DatabaseResultColumn" endspan --></font></td>
        </tr>
        <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan --></tbody>
    </table>
    <p> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber13">
      <tr>
        <td width="100%">
        <p align="left"><font size="2">Stone Mountain Warehouse</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">1625 Litton Rd</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Stone Mountain GA 30083</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber14">
      <tr>
        <td width="100%"><font size="2">770.496.1802</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">770.938.6247</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Fax 770.491.8625</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Distribution Manager - Erol Celebi</font></td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber15">
      <tr>
        <td width="100%">
        <p align="center"><a name="Higginsville"><font size="2">Higginsville</font></a></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">313 East Fifteenth St</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">PO Box 736 (For all mail)</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Higginsville MO 64037</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber16">
      <tr>
        <td width="100%"><font size="2">660.584.7454</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Fax 660.584.6247</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Warehouse 660.584.7317</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Warehouse Fax 660.584.7388</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber17">
      <tr>
        <td width="100%"><font size="2">Plant Manager - Geary Kingston</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Contact Person - Juanita Homfeld</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Production Manager - Mike Liese</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">Higginsville Extensions</font></td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber18">
      <tr>
        <td width="100%">
        <p align="center"><a name="Shreveport"><font size="2">Shreveport</font></a></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">7501 East Trammel Dr</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Shreveport LA 71108</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber19">
      <tr>
        <td width="100%"><font size="2">318.686.8836</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Fax 318.687.9339</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber20">
      <tr>
        <td width="100%"><font size="2">Plant Manager - James Maziarz</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Contact Person - Linda Marable</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber21">
      <tr>
        <td width="100%">
        <p align="center"><a name="El Campo"><font size="2">El Campo</font></a></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">1102 Blue Creek Rd</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">El Campo TX 77437</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber22">
      <tr>
        <td width="100%"><font size="2">979.543.8034</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Fax 979.543.2729</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber23">
      <tr>
        <td width="100%"><font size="2">Plant Manager - Larry Dyer</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Contact Person - Cindy Gussman</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">El Campo 
    Extensions</font></td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber24">
      <tr>
        <td width="100%">
        <p align="center"><a name="Tolleson"><font size="2">Tolleson</font></a></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">7980 W Buckeye Rd</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Phoenix AZ 85043</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber25" align="left">
      <tr>
        <td width="100%"><font size="2">623.936.1791</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Fax 623.936.5528</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Warehouse Fax 623.936.9734</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber26">
      <tr>
        <td width="100%"><font size="2">Plant Manager - Tom Jenniges</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Contact Person - Delia Villa</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <p align="center"><font size="2">Customer Service 800.292.2877</font></td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber27">
      <tr>
        <td width="100%"><font size="2">Machine Shop/Central Stores - Machine Assembly</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">2093 E Magnolia </font> </td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Phoenix AZ 85034</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber28">
      <tr>
        <td width="100%" align="center"><font size="2">623.936.1791 Ext 3274</font></td>
      </tr>
      <tr>
        <td width="100%" align="center"><font size="2">623.936.1791 Ext 3277</font></td>
      </tr>
      <tr>
        <td width="100%" align="center"><font size="2">623.936.1791 Ext 3268</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber29">
      <tr>
        <td width="100%" align="center"><font size="2">Fax 602.267.9871</font></td>
      </tr>
      <tr>
        <td width="100%" align="center"><font size="2">Fax 602.275.6276</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber30">
      <tr>
        <td width="100%">
        <p align="center"><a name="Mt. Sterling"><font size="2">Mt. Sterling</font></a></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">150 Fourth Ave</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">PO Box 216 (For all mail)</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Mt. Sterling OH 43143</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber31">
      <tr>
        <td width="100%" align="center"><font size="2">740.869.2964</font></td>
      </tr>
      <tr>
        <td width="100%" align="center"><font size="2">740.869.3187</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber32">
      <tr>
        <td width="100%"><font size="2">Plant Manager - Jim Dickerson</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Contact Person - Karen Rainsberger</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <a name="Corte Madera"><font size="2">Corte Madera</font></a></td>
    <td width="30%" style="border-style: none; border-width: medium" rowspan="3">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber33">
      <tr>
        <td width="100%">
        <p align="center"><font size="2">415.866.6001</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Fax 415.927.1059</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Warehouse Fax 510.232.1220</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Plant 
    Manager - Mark Musha</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">195 Tamal 
    Vista Blvd</font></td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Contact 
    Person - Stan Forsstrom</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">Corte 
    Madera CA 94925</font></td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Tech Group 
    Fax 415.886.6055</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">Corte 
    Madera Extensions</font></td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">Richmond 
    Warehouse</font></td>
    <td width="67%" style="border-style: none; border-width: medium" colspan="2">
    <font size="2">510.970.9730 - Daniel Newman</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="67%" style="border-style: none; border-width: medium" colspan="2">
    <font size="2">510.970.9731 - Anthony Singleton</font></td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <a name="West Chicago"><font size="2">West Chicago</font></a></td>
    <td width="30%" style="border-style: none; border-width: medium">
    <font size="2">630.231.0800</font></td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Plant 
    Manager - Richard Korff</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">1425 
    Hawthorne Lane</font></td>
    <td width="30%" style="border-style: none; border-width: medium">
    <font size="2">Fax 
    630.231.0817</font></td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Contact 
    Person - Desiree Morena</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">West 
    Chicago IL 60185</font></td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">West 
    Chicago Extensions</font></td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <a name="Metuchen"><font size="2">Metuchen</font></a></td>
    <td width="30%" style="border-style: none; border-width: medium">
    <font size="2">732.494.1999</font></td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Plant 
    Manager - Mike Revier</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">190 Liberty 
    St</font></td>
    <td width="30%" style="border-style: none; border-width: medium">
    <font size="2">Fax 
    732.494.6210</font></td>
    <td width="37%" style="border-style: none; border-width: medium">
    <font size="2">Contact 
    Person - Gloria Rizzolo Harvey</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium">
    <font size="2">Metuchen NJ 
    08840</font></td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium"> </td>
    <td width="30%" style="border-style: none; border-width: medium"> </td>
    <td width="37%" style="border-style: none; border-width: medium"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Metuchen Extensions</font></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Metuchen Distribution Center</font></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">732.287.3990</font></td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">64 Brunswick Ave</font></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Fax 732.287.6313</font></td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Edison NJ 08817</font></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3" valign="top">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <a name="Jacksonville"><font size="2">Jacksonville</font></a></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">904.783.1350</font></td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Plant Manager - Pat Garrity</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <a name="Jacksonville"><font size="2">5355 Shawland Rd</font></a></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Fax 904.783.8033</font></td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Contact Person - Cindy Grube</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <a name="Jacksonville"><font size="2">Jacksonville FL 32254</font></a></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Shipping Fax 904.783.1662</font></td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <a name="Jacksonville"><font size="2">Jacksonville Extensions</font></a></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="100%" style="border-style: none; border-width: medium" colspan="3" valign="top">
    <hr></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber35">
      <tr>
        <td width="100%"><a name="Jacksonville"><font size="2">Mooresville</font></a></td>
      </tr>
      <tr>
        <td width="100%"><a name="Jacksonville"><font size="2">314 Mooresville Blvd</font></a></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Mooresville NC 28115</font></td>
      </tr>
    </table>
    </td>
    <td width="30%" style="border-style: none; border-width: medium" rowspan="2" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber34">
      <tr>
        <td width="100%"><font size="2">704.660.6600</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Conference Call 704.658.1134</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Main Fax 704.660.7604</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Cust Svc Fax 704.660.6038</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Warehouse Fax 704.660.6040</font></td>
      </tr>
    </table>
    </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber36">
      <tr>
        <td width="100%"><font size="2">Plant Manager - Phil Goudreault</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Contact Person - Kathy Ritchie</font></td>
      </tr>
      <tr>
        <td width="100%"> </td>
      </tr>
      <tr>
        <td width="100%"><font size="2">HR Fax 704.660.6042</font></td>
      </tr>
      <tr>
        <td width="100%"><font size="2">Plant Office Fax 704.660.6039</font></td>
      </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Corp Fax 704.660.6036</font></td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top">
    <font size="2">Mooresville Extensions</font></td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
  <tr>
    <td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
    <td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
  </tr>
</table>
<p align="right"><font color="#000080" size="2"><i>Virtual Campus 2004.1.ASP</i></font></p>

<p align="right"> </p>

</body>

</html>

styrochem -> RE: Results Across Multiple Columns (9/9/2004 7:40:27)
I followed the directions on the Formatting Output in Rows in the supplied link but still cannot get it to work. Here is the section I need to modify to display records across in rows. Where exactly do I install this code? <!--webbot bot="DatabaseRegionStart" s-columnnames="emp_id,emp_login,emp_password,emp_level,name,title,email,work_phone,home_phone,cell_phone,address,dep_id,picture,manmonth,plant,company,department" s-columntypes="3,202,202,3,202,202,202,202,202,202,202,3,202,3,202,202,202" s-dataconnection="Employee" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="emps" s-displaycolumns="name,work_phone" s-criteria="[company] EQ [Wincup] + [plant] EQ [stonemountain] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'Wincup' AND plant = 'stonemountain') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No employees listed." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr>" startspan --><!--#include file="../_fpclass/fpdblib.inc"--> <% if 0 then %> <SCRIPT Language="JavaScript"> document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>"); </SCRIPT> <% end if %> <% fp_sQry="SELECT * FROM emps WHERE (company = 'Wincup' AND plant = 'stonemountain') ORDER BY name ASC" fp_sDefault="" fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No employees listed.</td></tr>" fp_sDataConn="Employee" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_sColTypes="&emp_id=3&emp_login=202&emp_password=202&emp_level=3&name=202&title=202&email=202&work_phone=202&home_phone=202&cell_phone=202&address=202&dep_id=3&picture=202&manmonth=3&plant=202&company=202&department=202&" fp_iDisplayCols=2 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %> <!--#include file="../_fpclass/fpdbrgn1.inc"--> <!--webbot bot="DatabaseRegionStart" endspan --><tr> <td><font size="2"> <!--webbot bot="DatabaseResultColumn" s-columnnames="emp_id,emp_login,emp_password,emp_level,name,title,email,work_phone,home_phone,cell_phone,address,dep_id,picture,manmonth,plant,company,department" s-column="name" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>name<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"name")%><!--webbot bot="DatabaseResultColumn" endspan --></font></td> <td><font size="2"> <!--webbot bot="DatabaseResultColumn" s-columnnames="emp_id,emp_login,emp_password,emp_level,name,title,email,work_phone,home_phone,cell_phone,address,dep_id,picture,manmonth,plant,company,department" s-column="work_phone" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>work_phone<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"work_phone")%><!--webbot bot="DatabaseResultColumn" endspan --></font></td> </tr> <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--> <!--webbot bot="DatabaseRegionEnd" endspan --></tbody>

BeTheBall -> RE: Results Across Multiple Columns (9/9/2004 13:30:00)
I think you need to paste a little more of your code. Just paste the whole page to be safe.

styrochem -> RE: Results Across Multiple Columns (9/10/2004 9:21:55)

This page only has the first database section installed but its where I need to first get this running before I add the other sections.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Phone List</title>
</head>

<body bgproperties="fixed">

<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="42%" style="border-style: none; border-width: medium" align="center">
<p align="center"><font size="2"><img border="0" src="WinCup.gif" width="232" height="105"></font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="158%" id="AutoNumber9" height="184" align="left">
<tr>
<td width="100%" height="19" align="center">
<p align="left"><font color="#000080" size="2"><b>WinCup Plants - Click below</b></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Stone Mountain</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Higginsville</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left">
<p align="left"><font size="2">Shreveport</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left">
<p align="left"><font size="2">El Campo</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Tolleson</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Mt. Sterling</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Corte Madera</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">West Chicago</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Metuchen</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Jacksonville</font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">Mooresville</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="42%" style="border-style: none; border-width: medium" align="center" valign="top"> </td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
</td>
<td width="28%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-width: 0" bordercolor="#111111" width="100%" id="AutoNumber8">
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber10">
<tr>
<td width="100%">
<p align="center"><a name="Stone Mountain"><font size="2">Stone Mountain</font></a></td>
</tr>
<tr>
<td width="100%"><font size="2">4640 Lewis Rd</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Stone Mountain GA 30083</font></td>
</tr>
<tr>
<td width="100%"> </td>
</tr>
<tr>
<td width="100%"><font size="2">Stone Mountain Extensions</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber11">
<tr>
<td width="100%"><font size="2">770.938.5281</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Fax 770.270.0510</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber12">
<tr>
<td width="100%"><font size="2">Plant Manager - Pat Collins</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Contact Person - Shonnia Houston</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<table>
<thead>
<tr>
<td><b>name</b></td>
<td><b>work_phone</b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM emps WHERE (company = 'Wincup' AND plant = 'stonemountain') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No employees listed.</td></tr>"
fp_sDataConn="Employee"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&emp_id=3&emp_login=202&emp_password=202&emp_level=3&name=202&title=202&email=202&work_phone=202&home_phone=202&cell_phone=202&address=202&dep_id=3&picture=202&manmonth=3&plant=202&company=202&department=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td><font size="2">
<%=FP_FieldVal(fp_rs,"name")%></font></td>
<td><font size="2">
<%=FP_FieldVal(fp_rs,"work_phone")%></font></td>
</tr>

</tbody>
</table>
<p> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber13">
<tr>
<td width="100%">
<p align="left"><font size="2">Stone Mountain Warehouse</font></td>
</tr>
<tr>
<td width="100%"><font size="2">1625 Litton Rd</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Stone Mountain GA 30083</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber14">
<tr>
<td width="100%"><font size="2">770.496.1802</font></td>
</tr>
<tr>
<td width="100%"><font size="2">770.938.6247</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Fax 770.491.8625</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Distribution Manager - Erol Celebi</font></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber15">
<tr>
<td width="100%">
<p align="center"><a name="Higginsville"><font size="2">Higginsville</font></a></td>
</tr>
<tr>
<td width="100%"><font size="2">313 East Fifteenth St</font></td>
</tr>
<tr>
<td width="100%"><font size="2">PO Box 736 (For all mail)</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Higginsville MO 64037</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber16">
<tr>
<td width="100%"><font size="2">660.584.7454</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Fax 660.584.6247</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Warehouse 660.584.7317</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Warehouse Fax 660.584.7388</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber17">
<tr>
<td width="100%"><font size="2">Plant Manager - Geary Kingston</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Contact Person - Juanita Homfeld</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Production Manager - Mike Liese</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">Higginsville Extensions</font></td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber18">
<tr>
<td width="100%">
<p align="center"><a name="Shreveport"><font size="2">Shreveport</font></a></td>
</tr>
<tr>
<td width="100%"><font size="2">7501 East Trammel Dr</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Shreveport LA 71108</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber19">
<tr>
<td width="100%"><font size="2">318.686.8836</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Fax 318.687.9339</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber20">
<tr>
<td width="100%"><font size="2">Plant Manager - James Maziarz</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Contact Person - Linda Marable</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber21">
<tr>
<td width="100%">
<p align="center"><a name="El Campo"><font size="2">El Campo</font></a></td>
</tr>
<tr>
<td width="100%"><font size="2">1102 Blue Creek Rd</font></td>
</tr>
<tr>
<td width="100%"><font size="2">El Campo TX 77437</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber22">
<tr>
<td width="100%"><font size="2">979.543.8034</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Fax 979.543.2729</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber23">
<tr>
<td width="100%"><font size="2">Plant Manager - Larry Dyer</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Contact Person - Cindy Gussman</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">El Campo
Extensions</font></td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber24">
<tr>
<td width="100%">
<p align="center"><a name="Tolleson"><font size="2">Tolleson</font></a></td>
</tr>
<tr>
<td width="100%"><font size="2">7980 W Buckeye Rd</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Phoenix AZ 85043</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber25" align="left">
<tr>
<td width="100%"><font size="2">623.936.1791</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Fax 623.936.5528</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Warehouse Fax 623.936.9734</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber26">
<tr>
<td width="100%"><font size="2">Plant Manager - Tom Jenniges</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Contact Person - Delia Villa</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<p align="center"><font size="2">Customer Service 800.292.2877</font></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber27">
<tr>
<td width="100%"><font size="2">Machine Shop/Central Stores - Machine Assembly</font></td>
</tr>
<tr>
<td width="100%"><font size="2">2093 E Magnolia </font> </td>
</tr>
<tr>
<td width="100%"><font size="2">Phoenix AZ 85034</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber28">
<tr>
<td width="100%" align="center"><font size="2">623.936.1791 Ext 3274</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">623.936.1791 Ext 3277</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">623.936.1791 Ext 3268</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber29">
<tr>
<td width="100%" align="center"><font size="2">Fax 602.267.9871</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 602.275.6276</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber30">
<tr>
<td width="100%">
<p align="center"><a name="Mt. Sterling"><font size="2">Mt. Sterling</font></a></td>
</tr>
<tr>
<td width="100%"><font size="2">150 Fourth Ave</font></td>
</tr>
<tr>
<td width="100%"><font size="2">PO Box 216 (For all mail)</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Mt. Sterling OH 43143</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber31">
<tr>
<td width="100%" align="center"><font size="2">740.869.2964</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">740.869.3187</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber32">
<tr>
<td width="100%"><font size="2">Plant Manager - Jim Dickerson</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Contact Person - Karen Rainsberger</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<a name="Corte Madera"><font size="2">Corte Madera</font></a></td>
<td width="30%" style="border-style: none; border-width: medium" rowspan="3">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber33">
<tr>
<td width="100%">
<p align="center"><font size="2">415.866.6001</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Fax 415.927.1059</font></td>
</tr>
<tr>
<td width="100%"><font size="2">Warehouse Fax 510.232.1220</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Plant
Manager - Mark Musha</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">195 Tamal
Vista Blvd</font></td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Contact
Person - Stan Forsstrom</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">Corte
Madera CA 94925</font></td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Tech Group
Fax 415.886.6055</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">Corte
Madera Extensions</font></td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">Richmond
Warehouse</font></td>
<td width="67%" style="border-style: none; border-width: medium" colspan="2">
<font size="2">510.970.9730 - Daniel Newman</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="67%" style="border-style: none; border-width: medium" colspan="2">
<font size="2">510.970.9731 - Anthony Singleton</font></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<a name="West Chicago"><font size="2">West Chicago</font></a></td>
<td width="30%" style="border-style: none; border-width: medium">
<font size="2">630.231.0800</font></td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Plant
Manager - Richard Korff</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">1425
Hawthorne Lane</font></td>
<td width="30%" style="border-style: none; border-width: medium">
<font size="2">Fax
630.231.0817</font></td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Contact
Person - Desiree Morena</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">West
Chicago IL 60185</font></td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">West
Chicago Extensions</font></td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<a name="Metuchen"><font size="2">Metuchen</font></a></td>
<td width="30%" style="border-style: none; border-width: medium">
<font size="2">732.494.1999</font></td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Plant
Manager - Mike Revier</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">190 Liberty
St</font></td>
<td width="30%" style="border-style: none; border-width: medium">
<font size="2">Fax
732.494.6210</font></td>
<td width="37%" style="border-style: none; border-width: medium">
<font size="2">Contact
Person - Gloria Rizzolo Harvey</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium">
<font size="2">Metuchen NJ
08840</font></td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium"> </td>
<td width="30%" style="border-style: none; border-width: medium"> </td>
<td width="37%" style="border-style: none; border-width: medium"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Metuchen Extensions</font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Metuchen Distribution Center</font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
<font size="2">732.287.3990</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<font size="2">64 Brunswick Ave</font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Fax 732.287.6313</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Edison NJ 08817</font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" valign="top">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<a name="Jacksonville"><font size="2">Jacksonville</font></a></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
<font size="2">904.783.1350</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Plant Manager - Pat Garrity</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<a name="Jacksonville"><font size="2">5355 Shawland Rd</font></a></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Fax 904.783.8033</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Contact Person - Cindy Grube</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<a name="Jacksonville"><font size="2">Jacksonville FL 32254</font></a></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top">
<font size="2">Shipping Fax 904.783.1662</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<a name="Jacksonville"><font size="2">Jacksonville Extensions</font></a></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="30%" style="border-style: none; border-width: medium" valign="top"> </td>
<td width="37%" style="border-style: none; border-width: medium" valign="top"> </td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" valign="top">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber35">
<tr>
<td width="100%"><a name="Jacksonville"><font size="2">Mooresville</font></a></td>
</tr>
<tr>
<td width="100%"><a name="Jacksonville"><font size="2">314 Mooresville Blvd</font></a></td>