|
| |
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
 |
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
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
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.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Results Across Multiple Columns - 8/17/2004 10:13:03
http://www.outfront.net/spooky/advanced.htm#Formatting
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
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
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
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...
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
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"><<</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>
</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
Posts: 212
Joined: 5/11/2004
Status: offline
|
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
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
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>
<!--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 i-checksum="10068" --><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 i-checksum="5948" --></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 i-checksum="32513" --></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 i-checksum="56926" --></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>
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Results Across Multiple Columns - 9/10/2004 9:56:18
OK, I think this will do it.
Find:
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="10068" --><tr>
Replace: <tr>
with
<%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
Then, I would find this:
<!--webbot bot="DatabaseResultColumn" endspan i-checksum="5948" --></font></td>
<td><font size="2">
and replace </td><td> with <br>
Finally, find:
<!--webbot bot="DatabaseResultColumn" endspan i-checksum="32513" --></font></td>
</tr>
and replace </td> with:
<% If x < 4 then %>
</td>
<%Else
x = 0%>
</td></tr>
<%end if%>
Give that a shot and let us know how it goes. The above method is generally used for results regions that display only one db field, like a picture, but with some tweaking it should work for you as well.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Results Across Multiple Columns - 9/23/2004 8:08:55
That seems to have fixed the problem but now I have a fortmatting issue. It works on the first section but in the second one it creates the first column neatly and then puts one record in the other four. Is there a way to resolve this? I included a screen shot to explain.
Here is also the sections 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="FALSE" s-recordsource="emps" s-displaycolumns="name,work_phone" s-criteria="[company] EQ [WinCup] + [plant] EQ [Higginsville] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'Higginsville') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="1" 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 = 'Higginsville') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3084" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="344" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --></font><br>
<td width="264" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center"><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 i-checksum="32513" --></font><% If x < 4 then %>
<%Else
x = 0%>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</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>
Thumbnail Image
 Attachment (1)
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Results Across Multiple Columns - 9/23/2004 9:32:18
Wonder if the problem is in your nested tables. I pasted your code into a new page, deleted everything after the </table> tag and it worked perfectly. Try pasting just the following into a new page and see how that works:
<table>
<tr>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
</tr>
<tr>
<td colspan="8"><hr></td>
<!--#include file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'Higginsville') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="344" style="border-bottom-style: solid; border-bottom-width: 1"><font size="2">
<%=FP_FieldVal(fp_rs,"name")%></font><br>
<td width="264" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center"><font size="2">
<%=FP_FieldVal(fp_rs,"work_phone")%></font><% If x < 4 then %>
<%Else
x = 0%>
</td></tr>
<%end if%>
</tr>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Results Across Multiple Columns - 9/23/2004 10:44:05
I have discovered the cause but how do I resolve it? It works with one table but when I add more than one it starts to act up. Is there a break or something I can include that will keep these tables from interferring with eachother?
Here is the Page code--
<table>
<tr>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
</tr>
<tr>
<td colspan="8"><hr></td>
<!--#include file="../_fpclass/fpdblib.inc"-->
<%
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 records returned.</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=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="344" style="border-bottom-style: solid; border-bottom-width: 1"><font size="2">
<%=FP_FieldVal(fp_rs,"name")%></font><br>
<td width="264" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center"><font size="2">
<%=FP_FieldVal(fp_rs,"work_phone")%></font><% If x < 4 then %>
<%Else
x = 0%>
</td></tr>
<%end if%>
</tr>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
<table>
<tr>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
<td>Name</td>
<td>
<p align="center">Phone</p>
</td>
</tr>
<tr>
<td colspan="8"><hr></td>
<!--#include file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'Higginsville') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="344" style="border-bottom-style: solid; border-bottom-width: 1"><font size="2">
<%=FP_FieldVal(fp_rs,"name")%></font><br>
<td width="264" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="center"><font size="2">
<%=FP_FieldVal(fp_rs,"work_phone")%></font><% If x < 4 then %>
<%Else
x = 0%>
</td></tr>
<%end if%>
</tr>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Results Across Multiple Columns - 9/24/2004 12:58:01
quote:
I have discovered the cause but how do I resolve it? It works with one table but when I add more than one it starts to act up. Is there a break or something I can include that will keep these tables from interferring with eachother?
Here is the Page code--
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Results Across Multiple Columns - 9/24/2004 13:29:38
Does it help any if you add a paragraph between tables? For example:
</table>
<p></p>
<table>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Results Across Multiple Columns - 9/24/2004 14:58:15
I copied your code and did not have the same trouble when running it through one of my pages. Maybe something outside the section you posted is causing the problem. Go ahead and post the code for the entire page, <html> to </html> and I'll take another look.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Results Across Multiple Columns - 9/24/2004 15:00:03
That is the entire page. I just took the original code you provided and then copied it with a database table adjustment.
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Results Across Multiple Columns - 9/24/2004 15:07:10
The page doesn't have tags like <html>, <head>, <body>, etc.?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Results Across Multiple Columns - 9/24/2004 15:10:08
Not yet since its been under troubleshooting. I have the original unaltered document I provided sections of if you want that one.
If so, here it is.
<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">
<a href="#Stone Mountain">Stone Mountain</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#Higginsville">Higginsville</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left">
<p align="left"><font size="2"><a href="#Shreveport">Shreveport</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left">
<p align="left"><font size="2"><a href="#El Campo">El Campo</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#Tolleson">Tolleson</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#Mt. Sterling">Mt. Sterling</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#Corte Madera">Corte Madera</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#West Chicago">West Chicago</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#Metuchen">Metuchen</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#Jacksonville">Jacksonville</a></font></td>
</tr>
<tr>
<td width="100%" height="15" align="left"><font size="2">
<a href="#Mooresville">Mooresville</a></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="59%" id="AutoNumber8" height="2408">
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="85">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber10">
<tr>
<td width="100%" bgcolor="#000080">
<p align="center"><b><a name="Stone Mountain"><font color="#FFFFFF">Stone Mountain</font></a></b></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%" bgcolor="#000080">
<p align="center"><b><font color="#FFFFFF">Stone Mountain Extensions</font></b></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="85">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber11">
<tr>
<td width="100%" align="center"><font size="2">770.938.5281</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 770.270.0510</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="85">
<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" height="142">
<table width="682">
<thead>
</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 i-checksum="10068" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
<p> </td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber13">
<tr>
<td width="100%">
<p align="center"><i><b><font color="#000080">Stone Mountain Warehouse</font></b></i></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" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber14">
<tr>
<td width="100%" align="center"><font size="2">770.496.1802</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">770.938.6247</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 770.491.8625</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" height="47">
<font size="2">Distribution Manager - Erol Celebi</font></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="62">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber15">
<tr>
<td width="100%" bgcolor="#000080">
<p align="center"><b><a name="Higginsville"><font color="#FFFFFF">Higginsville</font></a></b></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" height="62">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber16">
<tr>
<td width="100%" align="center"><font size="2">660.584.7454</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 660.584.6247</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Warehouse 660.584.7317</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Warehouse Fax 660.584.7388</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" height="62">
<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" height="17">
</td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" bgcolor="#000080" height="17">
<p align="center"><b>
<font color="#FFFFFF">Higginsville Extensions</font></b></td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" align="left" height="104">
<table width="682">
<thead>
</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="FALSE" s-recordsource="emps" s-displaycolumns="name,work_phone" s-criteria="[company] EQ [WinCup] + [plant] EQ [Higginsville] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'Higginsville') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="1" 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 = 'Higginsville') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3084" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber18">
<tr>
<td width="100%" bgcolor="#000080">
<p align="center"><font color="#FFFFFF"><b><a name="Shreveport">Shreveport</a></b></font></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" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber19">
<tr>
<td width="100%" align="center"><font size="2">318.686.8836</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 318.687.9339</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" height="47">
<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" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber21">
<tr>
<td width="100%" bgcolor="#000080">
<p align="center"><b><a name="El Campo"><font color="#FFFFFF">El Campo</font></a></b></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" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber22">
<tr>
<td width="100%" align="center"><font size="2">979.543.8034</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 979.543.2729</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" height="47">
<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" height="17">
</td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" bgcolor="#000080" height="17">
<p align="center"><font color="#FFFFFF"><b>El Campo
Extensions</b></font></td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="124">
<table>
<thead>
</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 [ElCampo] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'ElCampo') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="2" 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 = 'ElCampo') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=2
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="31181" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber24">
<tr>
<td width="100%" bgcolor="#000080">
<p align="center"><b><a name="Tolleson"><font color="#FFFFFF">Tolleson</font></a></b></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" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber25" align="left">
<tr>
<td width="100%" align="center"><font size="2">623.936.1791</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 623.936.5528</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Warehouse Fax 623.936.9734</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" height="47">
<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" height="13">
<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" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="66">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber27">
<tr>
<td width="100%" bgcolor="#000080"><b><font color="#FFFFFF">Machine Shop/Central Stores - Machine Assembly</font></b></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" height="66">
<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" height="66">
<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" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="62">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber30">
<tr>
<td width="100%" bgcolor="#000080">
<p align="center"><font color="#FFFFFF"><b><a name="Mt. Sterling">
<span style="background-color: #000080">Mt. Sterling</span></a></b></font></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" height="62">
<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" height="62">
<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" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" align="center" bgcolor="#000080" height="17">
<font color="#FFFFFF"><b>
<a name="Corte Madera">Corte Madera</a></b></font></td>
<td width="30%" style="border-style: none; border-width: medium" rowspan="3" height="47">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber33">
<tr>
<td width="100%" align="center">
<p align="center"><font size="2">415.866.6001</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Fax 415.927.1059</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Warehouse Fax 510.232.1220</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" height="17">
<font size="2">Plant
Manager - Mark Musha</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="13">
<font size="2">195 Tamal
Vista Blvd</font></td>
<td width="37%" style="border-style: none; border-width: medium" height="13">
<font size="2">Contact
Person - Stan Forsstrom</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="13">
<font size="2">Corte
Madera CA 94925</font></td>
<td width="37%" style="border-style: none; border-width: medium" height="13">
<font size="2">Tech Group
Fax 415.886.6055</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="16"></td>
<td width="30%" style="border-style: none; border-width: medium" height="16"></td>
<td width="37%" style="border-style: none; border-width: medium" height="16"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17" align="center" bgcolor="#000080">
<font color="#FFFFFF"><b>Corte
Madera Extensions</b></font></td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="165">
<table>
<thead>
</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 [CorteMadera] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'CorteMadera') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="3" 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 = 'CorteMadera') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=3
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="36743" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
</td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17"></td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="13">
<p align="center"><font color="#000080"><i><b>Richmond
Warehouse</b></i></font></td>
<td width="67%" style="border-style: none; border-width: medium" colspan="2" height="13">
<font size="2">510.970.9730 - Daniel Newman</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17"></td>
<td width="67%" style="border-style: none; border-width: medium" colspan="2" height="17">
<font size="2">510.970.9731 - Anthony Singleton</font></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="13" align="center" bgcolor="#000080">
<font color="#FFFFFF"><b>
<a name="West Chicago">West Chicago</a></b></font></td>
<td width="30%" style="border-style: none; border-width: medium" height="13" align="center">
<font size="2">630.231.0800</font></td>
<td width="37%" style="border-style: none; border-width: medium" height="13">
<font size="2">Plant
Manager - Richard Korff</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="13">
<font size="2">1425
Hawthorne Lane</font></td>
<td width="30%" style="border-style: none; border-width: medium" height="13" align="center">
<font size="2">Fax
630.231.0817</font></td>
<td width="37%" style="border-style: none; border-width: medium" height="13">
<font size="2">Contact
Person - Desiree Morena</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17">
<font size="2">West
Chicago IL 60185</font></td>
<td width="30%" style="border-style: none; border-width: medium" height="17" align="center"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17"></td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17" align="center" bgcolor="#000080">
<font color="#FFFFFF"><b>West
Chicago Extensions</b></font></td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="127">
<table>
<thead>
</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 [WestChicago] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'WestChicago') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="4" 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 = 'WestChicago') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=4
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="38169" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="13" align="center" bgcolor="#000080">
<font color="#FFFFFF"><b>
<a name="Metuchen">Metuchen</a></b></font></td>
<td width="30%" style="border-style: none; border-width: medium" height="13" align="center">
<font size="2">732.494.1999</font></td>
<td width="37%" style="border-style: none; border-width: medium" height="13">
<font size="2">Plant
Manager - Mike Revier</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="13">
<font size="2">190 Liberty
St</font></td>
<td width="30%" style="border-style: none; border-width: medium" height="13" align="center">
<font size="2">Fax
732.494.6210</font></td>
<td width="37%" style="border-style: none; border-width: medium" height="13">
<font size="2">Contact
Person - Gloria Rizzolo Harvey</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17">
<font size="2">Metuchen NJ
08840</font></td>
<td width="30%" style="border-style: none; border-width: medium" height="17" align="center"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" height="17"></td>
<td width="30%" style="border-style: none; border-width: medium" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="17" align="center" bgcolor="#000080">
<font color="#FFFFFF"><b>Metuchen Extensions</b></font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" valign="top" colspan="3" height="127">
<table>
<thead>
</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 [Metuchen] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'Metuchen') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="5" 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 = 'Metuchen') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=5
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="17095" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
</td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="1" align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber38">
<tr>
<td width="100%"><i><b>
<font color="#000080">Metuchen Distribution Center</font></b></i></td>
</tr>
<tr>
<td width="100%">
<font size="2">64 Brunswick Ave</font></td>
</tr>
<tr>
<td width="100%">
<font size="2">Edison NJ 08817</font></td>
</tr>
</table>
</td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="1" align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber37">
<tr>
<td width="100%" align="center">
<font size="2">732.287.3990</font></td>
</tr>
<tr>
<td width="100%" align="center">
<font size="2">Fax 732.287.6313</font></td>
</tr>
</table>
</td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" rowspan="2" height="1">
<table>
<thead>
</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 [MetuchenDistribution] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'MetuchenDistribution') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="6" 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 = 'MetuchenDistribution') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=6
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="30674" --><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 i-checksum="5948" --></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 i-checksum="32513" --></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 i-checksum="56926" --></tbody>
</table>
</td>
</tr>
<tr>
<td width="63%" style="border-style: none; border-width: medium" valign="top" height="1" colspan="2">
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" valign="top" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="13" align="center" bgcolor="#000080">
<font color="#FFFFFF"><b><a name="Jacksonville">Jacksonville</a></b></font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="13" align="center">
<font size="2">904.783.1350</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="13">
<font size="2">Plant Manager - Pat Garrity</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="13">
<a name="Jacksonville"><font size="2">5355 Shawland Rd</font></a></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="13" align="center">
<font size="2">Fax 904.783.8033</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="13">
<font size="2">Contact Person - Cindy Grube</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="17">
<a name="Jacksonville"><font size="2">Jacksonville FL 32254</font></a></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="17" align="center">
<font size="2">Shipping Fax 904.783.1662</font></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="17" align="center"></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="17" align="center" bgcolor="#000080">
<b>
<a name="Jacksonville"><font color="#FFFFFF">Jacksonville Extensions</font></a></b></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" valign="top" colspan="3" height="103">
<table>
<thead>
</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 [Jacksonville] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'Jacksonville') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="7" 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 = 'Jacksonville') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=7
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3903" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
</td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" colspan="3" valign="top" height="14">
<hr></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="77">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber35">
<tr>
<td width="100%" align="center" bgcolor="#000080"><font color="#FFFFFF">
<b><a name="Mooresville">Mooresville</a></b></font></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" height="96">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber34">
<tr>
<td width="100%" align="center"><font size="2">704.660.6600</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Conference Call 704.658.1134</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Main Fax 704.660.7604</font></td>
</tr>
<tr>
<td width="100%" align="center"><font size="2">Cust Svc Fax 704.660.6038</font></td>
</tr>
<tr>
<td width="100%" align="center"><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" height="77">
<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" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="17">
<font size="2">Corp Fax 704.660.6036</font></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
</tr>
<tr>
<td width="33%" style="border-style: none; border-width: medium" valign="top" height="17" align="center" bgcolor="#000080">
<font color="#FFFFFF"><b>Mooresville Extensions</b></font></td>
<td width="30%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
<td width="37%" style="border-style: none; border-width: medium" valign="top" height="17"></td>
</tr>
<tr>
<td width="100%" style="border-style: none; border-width: medium" valign="top" colspan="3" height="127">
<table>
<thead>
</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 [Mooresville] +" s-order="[name] +" s-sql="SELECT * FROM emps WHERE (company = 'WinCup' AND plant = 'Mooresville') ORDER BY name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="8" 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 = 'Mooresville') ORDER BY name ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</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=8
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="41630" --><%If x = 0 then %>
<tr>
<%end if%>
<%x=x+1%>
<td width="291" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="5948" --><br>
</font>
<td width="187" style="border-bottom-style: solid; border-bottom-width: 1"><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 i-checksum="32513" --><% If x < 3 then %>
<%Else
x = 0%> </font>
</td></tr>
<%end if%>
</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 i-checksum="56926" --></tbody>
</table>
</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>
| |
|
|
|
BeTheBall
Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Results Across Multiple Columns - 9/24/2004 15:22:56
Ahh. Took a minute for common sense to kick in. The problem is the variable "x". The values are carrying over from the first results section causing the alignment to be messed up. So, you need to reset the value of x to 0. Simply add the line in green (near the end) to every results section you add after the first one:
<%
fp_sQry="SELECT * FROM Results WHERE (CDbl(IDRS) > 4000) ORDER BY FName ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Team304"
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=1
fp_iRegion=BOTID
x=0
%>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Results Across Multiple Columns - 9/27/2004 7:32:20
That fixed it!!!! Thanks.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
