Re: FW: thanks

This is a real elementary question, but again I 'm new to this stuff. I
have a table that holds work requests for bidding and estimates. Once the
job is accepted I don't want that job to show up in the pending job list.
Up to this point I query all jobs in the REQUEST table and give the
supervisor a pick list of the all REQUEST to make assignments.

Maybe simply delete the request once it has been assigned. Maybe just
adding a field called ASSIGN =yes/no and not deleting it from the REQUEST.
Any suggestions, advantages and disadvantages to the ASSIGN field thing.

<CFQUERY DATASOURCE="Survey Status" Name="Assign">
SELECT *
FROM request
</CFQUERY>

<HR WIDTH="100%" align="center">
<CENTER><TABLE BORDER="0" WIDTH="700" >
<CAPTION valign="bottom"></CAPTION>

<TR BGCOLOR="CCCCCC">
<TH COLSPAN=6>
<cfoutput>
<CFIF Assign.recordcount IS 0>
<CENTER><H2>There are no new Survey projects!!!!</H2>
<CFELSE>
<H2>The following #Assign.recordcount# project(s) need Assignments!!!</H2>
<BR>
<H2>Select Township and Range, to assign Assignments and Surveyor</H2></CENTER>
</CFIF>
</cfoutput>
</TH>

<TR>
<TH BGCOLOR="CCCCCC">Requestor</TH>
<TH BGCOLOR="CCCCCC">Request Date</TH>
<TH BGCOLOR="CCCCCC">Gourp No.</TH>
<TH BGCOLOR="CCCCCC">T/R</TH>
<TH BGCOLOR="CCCCCC">Project Name</TH>
<TH BGCOLOR="CCCCCC">Estimator</TH>
</TR>

<CFOUTPUT QUERY="Assign">
<TR>
<TD BGCOLOR="FFFFFF">#Requestor#</TD>
<TD BGCOLOR="FFFFFF">#DateFormat(Left(RequestDate,10), 'MM/DD/YY')#</TD>
<TD BGCOLOR="FFFFFF">#RGrpNo#</TD>
<TD BGCOLOR="FFFFFF"><A HREF="assign.cfm?ID=#ID#">T.#RT# #RN#., R.#RR# 
#RE#.</A></TD>
<CFIF RProjectName IS "">
<CFSET #RProjectName# = ".">
<TD BGCOLOR="FFFFFF">#RProjectName#</TD>
</CFIF>
<TD BGCOLOR="FFFFFF">#Estimator#</TD>
</CFOUTPUT>
</TABLE>