OutFront Forums
     Home    Register     Search      Help      Login    

Follow Us
On Facebook
On Twitter
RSS
Via Email

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
 

Displaying one record if there are mulitples

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP, PHP, and Database >> Displaying one record if there are mulitples 		Page: [1]
 
spcafc

 

Posts: 89
Joined: 5/11/2004
Status: offline

  		Displaying one record if there are mulitples - 4/20/2009 10:31:31   
How do I get the DRW to only pull ONE record even if there are mulitples?

For example:

Agency A operates in 5 different locations with each location having it's own entry in the database. When the user clicks on the results link the DRW pulls ALL 5 locations although the user really only needs to see ONE.

To see this in action PLEASE visit the website and use these parameters:

Select Alamance from the drop down box.
Select Feral Cat Assistance Program from the list

It then shows all of the individual records - but I only need it to show the one pertaining to Alamance.
TexasWebDevelopers

 

Posts: 722
Joined: 2/22/2002
From: Dallas, TX
Status: offline

  		RE: Displaying one record if there are mulitples - 4/20/2009 12:10:29   
OK--I am a bit confused in the way you have the db designed.
When I followed your instructions Alamance>>Feral Cat I get ELEVEN returns that are exactly the same.
To eliminate duplicate entries in a db results you usually use DISTINCT in the SELECT statement like sql="SELECT DISTINCT field FROM table WHERE....and so on"
But in a relational db you don't need to have the feral cat information listed more than once...you have a table called "County" with all of your county names (listed only once). And a table called "shelters" with all of your shelters (listed only once). And then you relate the county to the shelter.
It looks like you have everything in one table.

_____________________________

:)

Follow us on TWITTER

(in reply to spcafc)
spcafc

 

Posts: 89
Joined: 5/11/2004
Status: offline

  		RE: Displaying one record if there are mulitples - 4/20/2009 20:22:27   

quote:

ORIGINAL: TexasWebDevelopers

OK--I am a bit confused in the way you have the db designed.
When I followed your instructions Alamance>>Feral Cat I get ELEVEN returns that are exactly the same.

This is because some of the agencyies operate in more then one county. Therefore they are listed more then once but with a different county as part of their record.

To eliminate duplicate entries in a db results you usually use DISTINCT in the SELECT statement like sql="SELECT DISTINCT field FROM table WHERE....and so on"
But in a relational db you don't need to have the feral cat information listed more than once...you have a table called "County" with all of your county names (listed only once). And a table called "shelters" with all of your shelters (listed only once). And then you relate the county to the shelter.
It looks like you have everything in one table.

Because the links listing is created when calling records that match the drop down choice. Then the link calls the record(s) from the database for the detail info. What i want to do is have the record called that matches the original drop down choice.


(in reply to TexasWebDevelopers)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Displaying one record if there are mulitples - 4/20/2009 20:43:31   
Sounds like you need to pass both parameters to the next step. You could probably format the results of the county search so that the links included a parameter of say, county=<%Request.Form("County"). Then, change the SQL for the final query to look for a match on the county and the name. That should restrict the results to only one record.

Does that make sense?

_____________________________

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.

(in reply to spcafc)
spcafc

 

Posts: 89
Joined: 5/11/2004
Status: offline

  		RE: Displaying one record if there are mulitples - 4/21/2009 7:12:35   
Yes - makes sense.

However I have no idea how to write that code or where to place it.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Displaying one record if there are mulitples - 4/21/2009 9:05:45   
But I see the page in question is now only displaying 1 record. You must have changed something. Did you find a solution?

_____________________________

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.

(in reply to spcafc)
spcafc

 

Posts: 89
Joined: 5/11/2004
Status: offline

  		RE: Displaying one record if there are mulitples - 4/21/2009 18:12:25   
Nope

(in reply to BeTheBall)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Displaying one record if there are mulitples - 4/21/2009 18:23:45   
Ahh right. I used a different search criteria. Can you post your code for the page?

_____________________________

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.

(in reply to spcafc)
spcafc

 

Posts: 89
Joined: 5/11/2004
Status: offline

  		RE: Displaying one record if there are mulitples - 4/22/2009 12:45:02    
<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">
<% ' 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>NCAWD Search</title>
<link rel="stylesheet" type="text/css" href="../images/style.css">
<script language="JavaScript">
<!--
function FP_openNewWindow(w,h,nav,loc,sts,menu,scroll,resize,name,url) {//v1.0
 var windowProperties=''; if(nav==false) windowProperties+='toolbar=no,'; else
  windowProperties+='toolbar=yes,'; if(loc==false) windowProperties+='location=no,'; 
 else windowProperties+='location=yes,'; if(sts==false) windowProperties+='status=no,';
 else windowProperties+='status=yes,'; if(menu==false) windowProperties+='menubar=no,';
 else windowProperties+='menubar=yes,'; if(scroll==false) windowProperties+='scrollbars=no,';
 else windowProperties+='scrollbars=yes,'; if(resize==false) windowProperties+='resizable=no,';
 else windowProperties+='resizable=yes,'; if(w!="") windowProperties+='width='+w+',';
 if(h!="") windowProperties+='height='+h; if(windowProperties!="") { 
  if( windowProperties.charAt(windowProperties.length-1)==',') 
   windowProperties=windowProperties.substring(0,windowProperties.length-1); } 
 window.open(url,name,windowProperties);
}
// -->
</script>
</head>

<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" bgcolor="#1A60A8" style="font-family: Verdana; font-size: 8pt">

<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table1" height="100%">
<tr>
<td valign="top" width="50%"> </td>
<td valign="top" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table2">
<tr>
<td>
<font size="1">
<img border="0" src="../images/blank.gif" width="764" height="8"></font></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table3">
<tr>
<td valign="top">
<!--webbot bot="Include" u-include="../includes/logo.htm" tag="BODY" --></td>
<td align="right" valign="bottom">
<!--webbot bot="Include" u-include="../includes/icons.htm" tag="BODY" --></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="23" bgcolor="#749CDF" align="right">
</td>
</tr>
<tr>
<td background="../images/top_hline.gif" class="blank" height="8"> </td>
</tr>
<tr>
<td valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table4">
<tr>
<td width="165" background="../images/leftline_back2.gif" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table5">
<tr>
<td background="../images/leftline_back1.gif" height="152" valign="top">
<!--webbot bot="Include" u-include="../includes/menu.htm" tag="BODY" --></td>
</tr>
<tr>
<td class="blank" height="1">
<font size="1">
<img border="0" src="../images/hline1.gif" width="165" height="1"></font></td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</td>
<td width="435" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table20">
<tr>
<td class="blank" valign="top">
</td>
</tr>
<tr>
<td class="blank" height="1">
<font size="1">
<img border="0" src="../images/hline1.gif" width="435" height="1"></font></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="10" cellspacing="0" width="100%" id="table21">
<tr>
<td valign="top">
<p style="margin-top: 0; margin-bottom: 2px">
<b><font style="font-size: 9pt">Disclaimer: This 
listing in no way endorses any of the organizations or 
individuals who are connected to those organizations. 
Please know that we cannot provide any other information 
about these organizations and we encourage you to ask 
for references or referrals before adopting from or 
donating to any of them.</font></b></p>
<p style="margin-top: 0; margin-bottom: 2px"> </p>

<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table25">
<tr>
<td valign="top" width="405" height="1238">

<p style="margin-top: 0; margin-bottom: 3px">

<b>

<font size="2" color="#46769E">Animal Welfare Organizations</font></b></p>
<p style="margin-top: 0; margin-bottom: 3px">
<font style="font-size: 9pt">To 
start your search please select a County from the dropdown list. From there 
click on the links to see full details for each agency. Be sure to check 
surrounding counties. For a map of NC Counties go 
<b> 
<a href="../nccountymap.htm">
<font color="#46769E" onclick="FP_openNewWindow('200', '200', true, true, true, true, true, false, '', /*href*/'../nccountymap.htm')">
<u>here</u></font></a></b>. 
</font></p>

<form method="POST" action="#animalwelfare">
<p style="margin-top: 0; margin-bottom: 3px">
<nobr>
<!--webbot bot="DatabaseRegionStart" s-columnnames="County" s-columntypes="202" s-dataconnection="db1" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="County" s-menuvalue="County" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Counties" s-displaycolumns="County" s-criteria="" s-order="[County] +" s-sql="SELECT * FROM Counties ORDER BY County ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="" s-norecordsfound="" i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="FALSE" --><!--#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 Counties ORDER BY County ASC"
fp_sDefault=""
fp_sNoRecords=""
fp_sDataConn="db1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="County"
fp_sMenuValue="County"
fp_sColTypes="&County=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3782" --><select NAME="County" SIZE="1">
<option selected value="Select One">Select One</option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
<option><%=FP_FieldHTML(fp_rs,"County")%></option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --><font size="1">  
</font> </nobr><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><input type="submit" value="Submit" name="B1"></font></p>
</form>

<p style="margin-top: 0; margin-bottom: 3px">
<font size="2" color="#46769E"><b>Shelters & Rescues</b></font></p>

<!--webbot bot="DatabaseRegionStart" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-columntypes="202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,3,3,3,3,3,3,202,202" s-dataconnection="db1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="5" b-makeform="FALSE" s-recordsource="Organizations" s-displaycolumns="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-criteria="[County] EQ {County} +" s-order="[Name] +" s-sql="SELECT * FROM Organizations WHERE (County =  '::County::') ORDER BY Name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="County=County" s-norecordsfound i-maxrecords="0" i-groupsize="0" botid="1" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><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></table>" 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 Organizations WHERE (County =  '::County::') ORDER BY Name ASC"
fp_sDefault="County=County"
fp_sNoRecords=""
fp_sDataConn="db1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Addition/Correction=202&Proof=202&Focus=202&Focus1=202&Focus2=202&Name=202&County=202&MailingAddress=202&MailingAddress2=202&City=202&State=202&ZipCode=202&PhysicalAddress=202&PhysicalAddress2=202&PhysicalCity=202&PhysicalState=202&PhysicalZipCode=202&Phone=202&Fax=202&Email=202&Website=202&vetCare=202&SN=202&LowCost=202&LowCost2=202&respondToComplaints=202&shelter=202&euthanize=202&rescueFosterSanctuary=202&educate=202&careAndTraining=202&shelterSupport=202&feralStrayTraps=202&other=202&Intake_Dog=3&Intake_Cat=3&Adoption_Dog=3&Adoption_Cat=3&Euthanasia_Dog=3&Euthanasia_Cat=3&SNFund=202&SNFund2=202&"
fp_iDisplayCols=42
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="47280" --><table BORDER="0">
	<tr>
		<td>
<p style="margin-top: 0; margin-bottom: 3px"><font size="1"><img border="0" src="../images/bullet2.gif"></font></td>
<td>
<p style="margin-top: 0; margin-bottom: 3px">
<a href="ncawdsearch.asp?Name=<%=FP_FieldURL(fp_rs,"Name")%>">
<font color="#1A60A8" style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalCity,PhysicalAddress2,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare501,SN501,LowCost501,LowCost5012,respondToComplaints501,shelter501,euthanize501,rescueFosterSanctuary501,educate501,careAndTraining501,shelterSupport501,feralStrayTraps501,other501,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Name" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Name<font size="-1">&gt;&gt;</font>" s-ColumnTypes="3,202,202,202,202,202,202,202,202,202,202,3,202,202,202,202,3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,3,3,3,3,3,3,202,202" startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3900" --></font></a></td>
</tr>
</table>
<hr color="#EEEEEE">
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><!--webbot bot="DatabaseRegionStart" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-columntypes="202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,3,3,3,3,3,3,202,202" s-dataconnection="db1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Organizations" s-displaycolumns="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,City,State,ZipCode,PhysicalAddress,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other" s-criteria="[Name] EQ {Name} +" s-order s-sql="SELECT * FROM Organizations WHERE (Name =  '::Name::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Name=" 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="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><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></table>" 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 Organizations WHERE (Name =  '::Name::')"
fp_sDefault="Name="
fp_sNoRecords="No records returned."
fp_sDataConn="db1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Addition/Correction=202&Proof=202&Focus=202&Focus1=202&Focus2=202&Name=202&County=202&MailingAddress=202&MailingAddress2=202&City=202&State=202&ZipCode=202&PhysicalAddress=202&PhysicalAddress2=202&PhysicalCity=202&PhysicalState=202&PhysicalZipCode=202&Phone=202&Fax=202&Email=202&Website=202&vetCare=202&SN=202&LowCost=202&LowCost2=202&respondToComplaints=202&shelter=202&euthanize=202&rescueFosterSanctuary=202&educate=202&careAndTraining=202&shelterSupport=202&feralStrayTraps=202&other=202&Intake_Dog=3&Intake_Cat=3&Adoption_Dog=3&Adoption_Cat=3&Euthanasia_Dog=3&Euthanasia_Cat=3&SNFund=202&SNFund2=202&"
fp_iDisplayCols=31
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3326" --><p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Name" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Name<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3900" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Updated:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Addition/Correction" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Addition/Correction<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Addition/Correction")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="48052" --> 
Type:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Proof" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Proof<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Proof")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="9674" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Animals helped:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Focus" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Focus<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Focus")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8702" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Focus1" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Focus1<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Focus1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15174" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Focus2" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Focus2<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Focus2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15182" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"> </p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Mailing Address:</span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="MailingAddress" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>MailingAddress<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"MailingAddress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="38890" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="City" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>City<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"City")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4267" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="State" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>State<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"State")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="10114" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="ZipCode" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ZipCode<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ZipCode")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13957" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
</p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Facility Address:</span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalAddress" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PhysicalAddress<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalAddress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="37106" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalCity" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PhysicalCity<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalCity")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29270" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalState" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PhysicalState<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalState")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="35117" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalZipCode" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PhysicalZipCode<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalZipCode")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="38960" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
</p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Phone:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Phone" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Phone<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Phone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8388" --> 
Fax:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Fax" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Fax<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Fax")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1677" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Email:
<a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>"><u><font color="#0000FF">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Email" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Email<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Email")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8328" --></font></u></a> 
<span style="font-size: 9pt">Website:
<a href="http://www.<%=FP_FieldLink(fp_rs,"Website")%>"><font color="#0000FF">
<u>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Website" b-tableformat="FALSE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Website<font size="-1">&gt;&gt;</font>" startspan --><%=FP_Field(fp_rs,"Website")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14512" --></u></font></a></span></p>
<p style="margin-top: 0; margin-bottom: 1px"> </p>
</span>
<p style="margin-top: 0; margin-bottom: 1px">
<font color="#000000" style="font-size: 9pt">Services Provided:</font><font style="font-size: 9pt">
</font><font color="#000000" style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="vetCare" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>vetCare<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"vetCare")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15297" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="respondToComplaints" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>respondToComplaints<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"respondToComplaints")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="55072" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="shelter" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>shelter<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"shelter")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15736" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="euthanize" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>euthanize<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"euthanize")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="22936" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="rescueFosterSanctuary" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>rescueFosterSanctuary<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"rescueFosterSanctuary")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1952" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="educate" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>educate<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"educate")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14162" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="careAndTraining" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>careAndTraining<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"careAndTraining")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="39132" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="shelterSupport" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>shelterSupport<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"shelterSupport")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="45584" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="feralStrayTraps" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>feralStrayTraps<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"feralStrayTraps")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="43147" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="other" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>other<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"other")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11935" --></font></p>
<span style="font-size: 9pt">
<p style="margin-top: 0; margin-bottom: 1px"> </p>
<p style="margin-top: 0; margin-bottom: 1px">
<font color="#000000">Low Cost Spay/Neuter Services:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="LowCost" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>LowCost<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"LowCost")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14196" --></font></p>
<p style="margin-top: 0; margin-bottom: 1px">
<font color="#000000">Spay/Neuter required before 
adoption:<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="LowCost2" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>LowCost2<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"LowCost2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14871" --></font></p>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></td>
</tr>
</table>
                    
<p><script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-536541-1");
pageTracker._trackPageview();
} catch(err) {}</script></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="164" background="../images/rightline_back2.gif" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table11">
<tr>
<td background="../images/rightline_back1.gif">
<table border="0" cellpadding="5" cellspacing="0" width="100%" id="table12">
<tr>
<td height="152" valign="top">
<!--webbot bot="Include" u-include="../includes/news.htm" tag="BODY" --></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="blank" height="1">
<font size="1">
<img border="0" src="../images/hline1.gif" width="164" height="1"></font></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="5" cellspacing="0" width="100%" id="table13">
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="blank" background="../images/hline3.gif" height="5"> </td>
</tr>
<tr>
<td align="center">
<!--webbot bot="Include" u-include="../includes/bottom.htm" tag="BODY" --></td>
</tr>
</table>
</td>
<td valign="top" width="50%"> </td>
</tr>
</table>
</body>

</html>

(in reply to BeTheBall)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Displaying one record if there are mulitples - 4/22/2009 17:33:52   
Give this a go. I made two edits, both in bold. 

<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">
<% ' 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>NCAWD Search</title>
<link rel="stylesheet" type="text/css" href="../images/style.css">
<script language="JavaScript">
<!--
function FP_openNewWindow(w,h,nav,loc,sts,menu,scroll,resize,name,url) {//v1.0
var windowProperties=''; if(nav==false) windowProperties+='toolbar=no,'; else
  windowProperties+='toolbar=yes,'; if(loc==false) windowProperties+='location=no,';
else windowProperties+='location=yes,'; if(sts==false) windowProperties+='status=no,';
else windowProperties+='status=yes,'; if(menu==false) windowProperties+='menubar=no,';
else windowProperties+='menubar=yes,'; if(scroll==false) windowProperties+='scrollbars=no,';
else windowProperties+='scrollbars=yes,'; if(resize==false) windowProperties+='resizable=no,';
else windowProperties+='resizable=yes,'; if(w!="") windowProperties+='width='+w+',';
if(h!="") windowProperties+='height='+h; if(windowProperties!="") {
  if( windowProperties.charAt(windowProperties.length-1)==',')
  windowProperties=windowProperties.substring(0,windowProperties.length-1); }
window.open(url,name,windowProperties);
}
// -->
</script>
</head>

<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" bgcolor="#1A60A8" style="font-family: Verdana; font-size: 8pt">

<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table1" height="100%">
<tr>
<td valign="top" width="50%"> </td>
<td valign="top" bgcolor="#FFFFFF">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table2">
<tr>
<td>
<font size="1">
<img border="0" src="../images/blank.gif" width="764" height="8"></font></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table3">
<tr>
<td valign="top">
<!--webbot bot="Include" u-include="../includes/logo.htm" tag="BODY" --></td>
<td align="right" valign="bottom">
<!--webbot bot="Include" u-include="../includes/icons.htm" tag="BODY" --></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="23" bgcolor="#749CDF" align="right">
</td>
</tr>
<tr>
<td background="../images/top_hline.gif" class="blank" height="8"> </td>
</tr>
<tr>
<td valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table4">
<tr>
<td width="165" background="../images/leftline_back2.gif" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table5">
<tr>
<td background="../images/leftline_back1.gif" height="152" valign="top">
<!--webbot bot="Include" u-include="../includes/menu.htm" tag="BODY" --></td>
</tr>
<tr>
<td class="blank" height="1">
<font size="1">
<img border="0" src="../images/hline1.gif" width="165" height="1"></font></td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</td>
<td width="435" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table20">
<tr>
<td class="blank" valign="top">
</td>
</tr>
<tr>
<td class="blank" height="1">
<font size="1">
<img border="0" src="../images/hline1.gif" width="435" height="1"></font></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="10" cellspacing="0" width="100%" id="table21">
<tr>
<td valign="top">
<p style="margin-top: 0; margin-bottom: 2px">
<b><font style="font-size: 9pt">Disclaimer: This
listing in no way endorses any of the organizations or
individuals who are connected to those organizations.
Please know that we cannot provide any other information
about these organizations and we encourage you to ask
for references or referrals before adopting from or
donating to any of them.</font></b></p>
<p style="margin-top: 0; margin-bottom: 2px"> </p>

<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table25">
<tr>
<td valign="top" width="405" height="1238">

<p style="margin-top: 0; margin-bottom: 3px">

<b>

<font size="2" color="#46769E">Animal Welfare Organizations</font></b></p>
<p style="margin-top: 0; margin-bottom: 3px">
<font style="font-size: 9pt">To
start your search please select a County from the dropdown list. From there
click on the links to see full details for each agency. Be sure to check
surrounding counties. For a map of NC Counties go
<b>
<a href="../nccountymap.htm">
<font color="#46769E" onclick="FP_openNewWindow('200', '200', true, true, true, true, true, false, '', /*href*/'../nccountymap.htm')">
<u>here</u></font></a></b>.
</font></p>

<form method="POST" action="#animalwelfare">
<p style="margin-top: 0; margin-bottom: 3px">
<nobr>
<!--webbot bot="DatabaseRegionStart" s-columnnames="County" s-columntypes="202" s-dataconnection="db1" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="County" s-menuvalue="County" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Counties" s-displaycolumns="County" s-criteria="" s-order="[County] +" s-sql="SELECT * FROM Counties ORDER BY County ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="" s-norecordsfound="" i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="FALSE" --><!--#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 Counties ORDER BY County ASC"
fp_sDefault=""
fp_sNoRecords=""
fp_sDataConn="db1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="County"
fp_sMenuValue="County"
fp_sColTypes="&County=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3782" --><select NAME="County" SIZE="1">
<option selected value="Select One">Select One</option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
<option><%=FP_FieldHTML(fp_rs,"County")%></option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --><font size="1">
</font> </nobr><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><input type="submit" value="Submit" name="B1"></font></p>
</form>

<p style="margin-top: 0; margin-bottom: 3px">
<font size="2" color="#46769E"><b>Shelters & Rescues</b></font></p>

<!--webbot bot="DatabaseRegionStart" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-columntypes="202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,3,3,3,3,3,3,202,202" s-dataconnection="db1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="5" b-makeform="FALSE" s-recordsource="Organizations" s-displaycolumns="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-criteria="[County] EQ {County} +" s-order="[Name] +" s-sql="SELECT * FROM Organizations WHERE (County =  '::County::') ORDER BY Name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="County=County" s-norecordsfound i-maxrecords="0" i-groupsize="0" botid="1" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><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></table>" 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 Organizations WHERE (County =  '::County::') ORDER BY Name ASC"
fp_sDefault="County=County"
fp_sNoRecords=""
fp_sDataConn="db1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Addition/Correction=202&Proof=202&Focus=202&Focus1=202&Focus2=202&Name=202&County=202&MailingAddress=202&MailingAddress2=202&City=202&State=202&ZipCode=202&PhysicalAddress=202&PhysicalAddress2=202&PhysicalCity=202&PhysicalState=202&PhysicalZipCode=202&Phone=202&Fax=202&Email=202&Website=202&vetCare=202&SN=202&LowCost=202&LowCost2=202&respondToComplaints=202&shelter=202&euthanize=202&rescueFosterSanctuary=202&educate=202&careAndTraining=202&shelterSupport=202&feralStrayTraps=202&other=202&Intake_Dog=3&Intake_Cat=3&Adoption_Dog=3&Adoption_Cat=3&Euthanasia_Dog=3&Euthanasia_Cat=3&SNFund=202&SNFund2=202&"
fp_iDisplayCols=42
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="47280" --><table BORDER="0">
  <tr>
      <td>
<p style="margin-top: 0; margin-bottom: 3px"><font size="1"><img border="0" src="../images/bullet2.gif"></font></td>
<td>
<p style="margin-top: 0; margin-bottom: 3px">
<a href="ncawdsearch.asp?Name=<%=FP_FieldURL(fp_rs,"Name")%>&County=<%=Request.Form("County")%>">
<font color="#1A60A8" style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalCity,PhysicalAddress2,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare501,SN501,LowCost501,LowCost5012,respondToComplaints501,shelter501,euthanize501,rescueFosterSanctuary501,educate501,careAndTraining501,shelterSupport501,feralStrayTraps501,other501,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Name" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Name<font size="-1">>></font>" s-ColumnTypes="3,202,202,202,202,202,202,202,202,202,202,3,202,202,202,202,3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,3,3,3,3,3,3,202,202" startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3900" --></font></a></td>
</tr>
</table>
<hr color="#EEEEEE">
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><!--webbot bot="DatabaseRegionStart" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-columntypes="202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,3,3,3,3,3,3,202,202" s-dataconnection="db1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Organizations" s-displaycolumns="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,City,State,ZipCode,PhysicalAddress,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other" s-criteria="[Name] EQ {Name} +" s-order s-sql="SELECT * FROM Organizations WHERE (Name =  '::Name::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Name=" 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="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><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></table>" 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 Organizations WHERE (Name =  '::Name::' AND County = '::County::')"
fp_sDefault="Name="
fp_sNoRecords="No records returned."
fp_sDataConn="db1"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Addition/Correction=202&Proof=202&Focus=202&Focus1=202&Focus2=202&Name=202&County=202&MailingAddress=202&MailingAddress2=202&City=202&State=202&ZipCode=202&PhysicalAddress=202&PhysicalAddress2=202&PhysicalCity=202&PhysicalState=202&PhysicalZipCode=202&Phone=202&Fax=202&Email=202&Website=202&vetCare=202&SN=202&LowCost=202&LowCost2=202&respondToComplaints=202&shelter=202&euthanize=202&rescueFosterSanctuary=202&educate=202&careAndTraining=202&shelterSupport=202&feralStrayTraps=202&other=202&Intake_Dog=3&Intake_Cat=3&Adoption_Dog=3&Adoption_Cat=3&Euthanasia_Dog=3&Euthanasia_Cat=3&SNFund=202&SNFund2=202&"
fp_iDisplayCols=31
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3326" --><p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Name" b-tableformat="FALSE" 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="3900" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Updated:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Addition/Correction" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Addition/Correction<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Addition/Correction")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="48052" -->
Type:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Proof" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Proof<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Proof")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="9674" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Animals helped:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Focus" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Focus<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Focus")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8702" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Focus1" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Focus1<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Focus1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15174" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Focus2" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Focus2<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Focus2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15182" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"> </p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Mailing Address:</span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="MailingAddress" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>MailingAddress<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"MailingAddress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="38890" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="City" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>City<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"City")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4267" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="State" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>State<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"State")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="10114" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="ZipCode" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ZipCode<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ZipCode")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13957" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
</p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Facility Address:</span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalAddress" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PhysicalAddress<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalAddress")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="37106" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
<span style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalCity" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PhysicalCity<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalCity")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29270" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalState" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PhysicalState<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalState")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="35117" -->
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="PhysicalZipCode" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PhysicalZipCode<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PhysicalZipCode")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="38960" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px">
</p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Phone:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Phone" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Phone<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Phone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8388" -->
Fax:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Fax" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Fax<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Fax")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1677" --></span></p>
<p style="margin-top: 0; margin-bottom: 1px"><span style="font-size: 9pt">Email:
<a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>"><u><font color="#0000FF">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Email" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Email<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Email")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8328" --></font></u></a>
<span style="font-size: 9pt">Website:
<a href="http://www.<%=FP_FieldLink(fp_rs,"Website")%>"><font color="#0000FF">
<u>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="Website" b-tableformat="FALSE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Website<font size="-1">>></font>" startspan --><%=FP_Field(fp_rs,"Website")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14512" --></u></font></a></span></p>
<p style="margin-top: 0; margin-bottom: 1px"> </p>
</span>
<p style="margin-top: 0; margin-bottom: 1px">
<font color="#000000" style="font-size: 9pt">Services Provided:</font><font style="font-size: 9pt">
</font><font color="#000000" style="font-size: 9pt">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="vetCare" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>vetCare<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"vetCare")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15297" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="respondToComplaints" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>respondToComplaints<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"respondToComplaints")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="55072" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="shelter" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>shelter<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"shelter")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15736" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="euthanize" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>euthanize<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"euthanize")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="22936" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="rescueFosterSanctuary" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>rescueFosterSanctuary<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"rescueFosterSanctuary")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1952" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="educate" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>educate<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"educate")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14162" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="careAndTraining" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>careAndTraining<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"careAndTraining")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="39132" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="shelterSupport" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>shelterSupport<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"shelterSupport")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="45584" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="feralStrayTraps" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>feralStrayTraps<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"feralStrayTraps")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="43147" -->,
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="other" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>other<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"other")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11935" --></font></p>
<span style="font-size: 9pt">
<p style="margin-top: 0; margin-bottom: 1px"> </p>
<p style="margin-top: 0; margin-bottom: 1px">
<font color="#000000">Low Cost Spay/Neuter Services:
<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="LowCost" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>LowCost<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"LowCost")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14196" --></font></p>
<p style="margin-top: 0; margin-bottom: 1px">
<font color="#000000">Spay/Neuter required before
adoption:<!--webbot bot="DatabaseResultColumn" s-columnnames="Addition/Correction,Proof,Focus,Focus1,Focus2,Name,County,MailingAddress,MailingAddress2,City,State,ZipCode,PhysicalAddress,PhysicalAddress2,PhysicalCity,PhysicalState,PhysicalZipCode,Phone,Fax,Email,Website,vetCare,SN,LowCost,LowCost2,respondToComplaints,shelter,euthanize,rescueFosterSanctuary,educate,careAndTraining,shelterSupport,feralStrayTraps,other,Intake_Dog,Intake_Cat,Adoption_Dog,Adoption_Cat,Euthanasia_Dog,Euthanasia_Cat,SNFund,SNFund2" s-column="LowCost2" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>LowCost2<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"LowCost2")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="14871" --></font></p>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></td>
</tr>
</table>

<p><script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-536541-1");
pageTracker._trackPageview();
} catch(err) {}</script></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="164" background="../images/rightline_back2.gif" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table11">
<tr>
<td background="../images/rightline_back1.gif">
<table border="0" cellpadding="5" cellspacing="0" width="100%" id="table12">
<tr>
<td height="152" valign="top">
<!--webbot bot="Include" u-include="../includes/news.htm" tag="BODY" --></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="blank" height="1">
<font size="1">
<img border="0" src="../images/hline1.gif" width="164" height="1"></font></td>
</tr>
<tr>
<td>
<table border="0" cellpadding="5" cellspacing="0" width="100%" id="table13">
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="blank" background="../images/hline3.gif" height="5"> </td>
</tr>
<tr>
<td align="center">
<!--webbot bot="Include" u-include="../includes/bottom.htm" tag="BODY" --></td>
</tr>
</table>
</td>
<td valign="top" width="50%"> </td>
</tr>
</table>
</body>

</html>


_____________________________

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.

(in reply to spcafc)
spcafc

 

Posts: 89
Joined: 5/11/2004
Status: offline

  		RE: Displaying one record if there are mulitples - 4/23/2009 7:07:53   
That works. However instead of opening the link in a new page it just puts the data at the bottom of the list - and the formatting of the info is messed up.

How to I get it to open in the new page and format correctly?

(in reply to BeTheBall)
BeTheBall

 

Posts: 6493
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Displaying one record if there are mulitples - 4/23/2009 9:32:38   
You would have to move the 3rd DRW to a new page and put the URL of that new page as the URL in the links that generate after one chooses a County.

_____________________________

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.

(in reply to spcafc)
Page:   [1]

All Forums >> Web Development >> ASP, PHP, and Database >> Displaying one record if there are mulitples 		Page: [1]
Jump to: 1





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


Copyright © 2009 Thomas Brunt's OutFront Inc. All Rights Reserved.