RE: FW: thanks

you can either delete the job from the table or add another column and call
it something (like job_active) and make it a required bit.

then just set the query to get * from the dB where job_active is 1 (Where 1
makes the job active and 0 makes it not active)

Thanks,
Richard C. Martin
Web Developer
Inficad Computing and Design, LLC
http://www.inficad.com
888.265.4423 ext 106
Azizona's Internet Onranp!

-----Original Message-----
From: dwiese@xxxxxxxxxxxxx [mailto:dwiese@xxxxxxxxxxxxx]
Sent: Thursday, July 13, 2000 9:18 AM
To: azcfug-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx
Subject: Re: [azcfug] 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>


------------------------------------------------------------------------
BTW: Did you buy that new car yet?
If not, check this site out.
They're called CarsDirect.com and it's a pretty sweet way to buy a car.
http://click.egroups.com/1/6847/13/_/_/_/963508934/
------------------------------------------------------------------------

To unsubscribe from this group, send an email to:
azcfug-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx