<p>
<cfFORM action="listingseditpkarticle.cfm?requesttimeout=600" method="post"  enctype="multipart/form-data">

	  <b><font SIZE="-1" FACE="verdana">Search For:</font></b>
  
	  <cfinput NAME="searcher" SIZE="65" required="yes" message="you must enter something to search for."><input type="submit" Value="Go  ">
  
  </cfFORM>
  
</p>




<hr>


<img src="http://www.cityguideny.com/nymetroparents-com.gif"><p>

    
    <cfif parameterexists(form.searcher) >
    
    <cfparam name="getrecord.name" default="#form.searcher#">
    
    <cfelse>
        <cfparam name="url.id" default="0">


  <cfquery name="getrecord" datasource="#ds#" timeout="600">
select ParentsListings.advertiser as advar,ParentsListings.*
from ParentsListings
where id = #url.id#
</cfquery>
</cfif>


<cfoutput>
<font face="Verdana, Geneva, sans-serif" size="+1"><b>#getrecord.name# Articles on NYMetroParents.com Report</span></b><br>
<table width=100% cellspacing=0 cellpadding=0 bgcolor=#color#><tr><td></td></tr></table>
<font face=verdana size=-1>
</cfoutput>
<p>

<CFQUERY name="wba" datasource="#ds#">
select columntable.id,columntable.title,columntable.blurb,columntable.copy,views,columntable.dateposted,columntable.datesubmitted
from columntable
where mag = 5 and match (columntable.title,columntable.copy) against ('"#getrecord.name#"' IN BOOLEAN MODE)
order by dateposted desc
limit 0,100
</CFQUERY>

<table cellspacing="0" cellpadding="4" border="1">
<Tr bgcolor="black">
<Td><font face="Verdana, Geneva, sans-serif" size=-1 color="white"><b>HEADLINE</b></font></Td>
<Td><font face="Verdana, Geneva, sans-serif" size=-1 color="white"><b>DATE POSTED</b></font></Td>
<Td><font face="Verdana, Geneva, sans-serif" size=-1 color="white"><b>ORIG. DATE</b></font></Td>

<Td><font face="Verdana, Geneva, sans-serif" size=-1 color="white"><b>VIEWS</b></font></Td>
</Tr>

<Cfoutput query="wba">
<tr>
<Td>
<a href="http://nymetroparents.com/2011va.cfm?colid=#wba.id#"><font style="text-decoration: none" face=verdana size=-1><strong>#title#</strong></a>
</td>
<Td>#dateformat(dateposted,'m/d/yyyy')#</Td>
<Td>#dateformat(datesubmitted,'m/d/yyyy')#</Td>

<Td><cfset zz = #views# * 2.1> #round(zz)# </Td>

</tr>
</cfoutput>
</td></tr></table>