<Cfquery name="Getrequests" datasource="#ds#">
select * from groupdb
where id > 830
order by id desc
limit 0,1000
</cfquery>



<!---
<form name=log action="nymprequests.cfm?rep=on" method="post">

<input name="searcher" placeholder="Client">

<select name="area">
<Cfif parameterexists(form.area) and #form.area# is not ''><cfoutput><option value="#form.area#">#form.area#</option></cfoutput></Cfif>
<Cfif parameterexists(url.area) and #url.area# is not ''><cfoutput><option value="#url.area#">#url.area#</option></cfoutput></Cfif>

<option value="">View All Areas</option>
<cfquery name="getars" datasource="#ds#">select distinct area from mediakit where area <> '' and area <> "-1'" order by area</cfquery><cfoutput query="getars"><option value="#area#">#area#</a></cfoutput></select>

<Cfoutput>
Request Month Start:
<select name="datetime">

<Cfif parameterexists(form.datetime) and #form.datetime# is not ''><option value="#form.datetime#">#form.datetime#</option></Cfif>
<Cfif parameterexists(url.datetime) and #url.datetime# is not ''><option value="#url.datetime#">#url.datetime#</option></Cfif>


<option value="">View All Months</option>
<Cfloop from="1" to="12" index="i">
<option value="#i#">#i#</option>
</Cfloop>
</select>
<select name="datetimeyear">

<Cfif parameterexists(form.datetimeyear) and #form.datetimeyear# is not ''><option value="#form.datetimeyear#">#form.datetimeyear#</option></Cfif>
<Cfif parameterexists(url.datetimeyear) and #url.datetimeyear# is not ''><option value="#url.datetimeyear#">#url.datetimeyear#</option></Cfif>


<option value="">View All Years</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>

</select>


Request Month End:
<select name="laststatussent">
<Cfif parameterexists(form.laststatussent) and #form.laststatussent# is not ''><option value="#form.laststatussent#">#form.laststatussent#</option></Cfif>
<Cfif parameterexists(url.laststatussent) and #url.laststatussent# is not ''><option value="#url.laststatussent#">#url.laststatussent#</option></Cfif>


<option value="">View All Months</option>
<Cfloop from="1" to="12" index="i">
<option value="#i#">#i#</option>
</Cfloop>
</select>
<select name="laststatussentyear">
<Cfif parameterexists(form.laststatussentyear) and #form.laststatussentyear# is not ''><option value="#form.laststatussentyear#">#form.laststatussentyear#</option></Cfif>
<Cfif parameterexists(url.laststatussentyear) and #url.laststatussentyear# is not ''><option value="#url.laststatussentyear#">#url.laststatussentyear#</option></Cfif>

<option value="">View All Years</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>

</select>


<select name="nymptag">
<Cfif parameterexists(form.nymptag) and #form.nymptag# is not ''><option value="#form.nymptag#">#form.nymptag#</option></Cfif>
<Cfif parameterexists(url.nymptag) and #url.nymptag# is not ''><option value="#url.nymptag#">#url.nymptag#</option></Cfif>
<option value="">View All Cats</option>

<option value="After school">After School</option>
<option value="Birthday">Birthday</option>
<option value="Camp">Camp</option>
<option value="Education">Education</option>
<option value="Family Activity">Family Activity</option>
<option value="Health">Health</option>
<option value="Special Needs">Special Needs</option>
<option value="Other">Other</option>

</select>

 </Cfoutput>


<input type="submit" Value="Filter"></font></form>
--->

<table border="1" cellpadding="4" cellspacing="0"><tr bgcolor="black">
	<Td><font face=verdana size=-1 color="white"><b></b></font></Td>

<Td><font face=verdana size=-1 color="white"><b>questiontype</b></font></Td>
<Td><font face=verdana size=-1 color="white"><b>when</b></font></Td>
<Td><font face=verdana size=-1 color="white"><b>author</b></font></Td>
<Td><font face=verdana size=-1 color="white"><b>email</b></font></Td>

<Td><font face=verdana size=-1 color="white"><b>message</b></font></Td>
<Td><font face=verdana size=-1 color="white"><b>groupname</b></font></Td>
<Td><font face=verdana size=-1 color="white"><b>number</b></font></Td>

</tr>
<Cfoutput query="Getrequests">
	<tr>
		<Td>#dateformat(dt,'m/d/yyyy')#</Td>

<Td>#questiontype#</Td>
<Td>#subject#</Td>
<Td>#author#</Td>
<Td>#email#</Td>

<Td>#temp#</Td>
<Td>#groupname#</Td>
<Td>#numberinparty#</Td>
</tr>
</Cfoutput>
</table>