 	<cfset utilities.setAppBL()>
 
 
-	<cfquery name="d" dbtype="query">
-		select ip from rip group by ip
-	</cfquery>
 
 	<cfquery name="subnetfromip" dbtype="query">
 		select


	<table border id="t" class="sortable">
		<tr>
			<th>IP</th>
			<th>IP_Activity</th>
			<th>subnet</th>
			<!----
			<th>listdate</th>
			<th>tools</th>
			---->
		</tr>
		<cfloop query="d">
			<tr>
				<td>#d.ip#</td>
				<cfquery name="tl" dbtype="query">
					select * from rip where ip='#d.ip#'
				</cfquery>
				<td>
					<table border>
						<tr>
							<th>listdate</th>
							<th>lastdate</th>
							<th>status</th>
						</tr>
						<cfloop query="#tl#">
							<tr>
								<td>#LISTDATE#</td>
								<td>#LASTDATE#</td>
								<td>#STATUS#</td>

						</cfloop>
					</table>
				</td>



				<!----
				<td>#listdate#</td>
				<td>
