Re: FW: thanks

Well. I would recommend to add a new column, if you
ever want to check the past records.


Terence Chang
AIM: peanutlen

--- dwiese@xxxxxxxxxxxxx wrote:
> 
> 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>
> 
> 


__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail ? Free email you can access from anywhere!
http://mail.yahoo.com/