Sorry. I thought that would be legible but the code definitely came out hard
to read didn't it? I'll try it again
<CFQUERY NAME="Project_Info" DATASOURCE="Projects_DB">
SELECT *
FROM Gen
ORDER BY McsalProjNumb DESC
</CFQUERY>
<html>
<head>
<title>Page Name</title>
</head>
<body>
<table border="1" cellpadding="2" cellspacing="0" bordercolor="#3366CC"
id="akram"> <tr bgcolor="#D6EFB5" class="bodyText"> <th
nowrap="nowrap"><span>Project Number</span></th> <th
nowrap="nowrap"><span>Project Name</span></th> <th
nowrap="nowrap"><span>Location</span></th>
<th nowrap="nowrap"><span>Category</span></th>
<th nowrap="nowrap"><span>Status</span></th>
<th nowrap="nowrap"><span>Owner</span></th>
<th nowrap="nowrap"><span>Owner's Contact</span></th>
<th nowrap="nowrap"><span>Architect</span></th>
<th nowrap="nowrap"><span>Architect Contact</span></th>
<th nowrap="nowrap"><span>Project Type</span></th> <th
nowrap="nowrap"><span>Principal</span></th>
<th nowrap="nowrap"><span>Completion Date</span></th>
<th nowrap="nowrap"><span>Project <br />Details
</span></th> </tr>
<CFLOOP QUERY="Project_info">
<CFIF #Project_info.ProjectID# IS "7">
<CFOUTPUT>
<form action="test.cfm?DBSearchFrom=DoEdit&DBSearchID=#ProjectID#"
method="post">
<tr>
<td nowrap="nowrap"><input type="text" name="McsalProjNumb"
id="UPMcsalProjNumb" size="15" value="#McsalProjNumb#"></td>
<td nowrap="nowrap"><input type="text" name="ProjName" id="ProjName" size="75"
value="#ProjName#"></td>
<td nowrap="nowrap"><input type="text" name="LocationCity" id="LocationCity"
size="20" value="#LocationCity#">, <input type="text" name="LocationState"
id="LocationState" size="2" value="#LocationState#"></td>
<td nowrap="nowrap"><input type="text" name="Category" id="Category" size="10"
value="#Category#"></td>
<td nowrap="nowrap"><input type="text" name="Status" id="Status" size="15"
value="#Status#"></td>
<td nowrap="nowrap"><input type="text" name="Owner" id="Owner" size="25"
value="#Owner#"></td>
<td nowrap="nowrap"><input type="text" name="OwnerCont" id="OwnerCont"
size="25" value="#OwnerCont#"></td>
<td nowrap="nowrap"><input type="text" name="Architect" id="Architect"
size="25" value="#Architect#"></td>
<td nowrap="nowrap"><input type="text" name="ArchitectCont" id="ArchitectCont"
size="25" value="#ArchitectCont#"></td>
<td nowrap="nowrap"><input type="text" name="ProjType" id="ProjType" size="15"
value="#ProjType#"></td>
<td nowrap="nowrap"><input type="text" name="Principal" id="Principal"
size="25" value="#Principal#"></td>
<td nowrap="nowrap"><input type="text" name="ActCompletDate"
id="ActCompletDate" size="10"
value="#DateFormat(ActCompletDate,"mm/dd/yyyy")#"></td>
<td>
<input type="submit" value="Update">
</form>
</td>
</tr>
</CFOUTPUT>
<CFELSE>
<!-- This is where all the data get's nicely output into the table -->
<CFOUTPUT>
<tr bgcolor="##E6F3FF">
<td nowrap="nowrap">#Project_info.McsalProjNumb#</td>
<td nowrap="nowrap"><a
href="Project_Spreadsheet_Short.cfm?Proj_Data_ID=#Project_info.ProjectID#">#Project_info.ProjName#</a></td>
<td nowrap="nowrap">#Project_info.LocationCity#,
#Project_info.LocationState#</td> <td
nowrap="nowrap">#Project_info.Category#</td>
<td nowrap="nowrap">#Project_info.Status#</td>
<td nowrap="nowrap">#Project_info.Owner#</td>
<td nowrap="nowrap">#Project_info.OwnerCont#</td>
<td nowrap="nowrap">#Project_info.Architect#</td>
<td nowrap="nowrap">#Project_info.ArchitectCont#</td>
<td nowrap="nowrap"><a
href="Cat_OverviewForm.cfm?Proj_DB_Cat=#Project_info.ProjType#">#Project_info.ProjType#</a></td>
<td nowrap="nowrap">#Project_info.Principal#</td>
<td
nowrap="nowrap">#DateFormat(Project_info.ActCompletDate,"mm/dd/yyyy")#</td>
<td></td>
</tr>
</CFOUTPUT>
</CFIF>
</CFLOOP>
</table>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4960
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
