home *** CD-ROM | disk | FTP | other *** search
/ Information Operations Fundamentals 2001 February / Information_Operations_Fundamentals_Unclassified_Version_1.0_February_2001.iso / modulequerylog.cfm < prev    next >
Text File  |  2000-09-19  |  2KB  |  77 lines
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  2.  
  3. <html>
  4. <head>
  5.     <title>Comments regarding <CFOUTPUT>#URL.Modules#</CFOUTPUT></title>
  6. </head>
  7.  
  8. <body>
  9.  
  10.  <CFQUERY NAME="GetComments" DATASOURCE="io">
  11.     SELECT ID, Source, Type, Urgency, Status, Person_Responsible, Date_Closed, Date_Entered, Content_Area, Feedback_Point, Notes, Resolution
  12.     FROM Log
  13.     WHERE Modules ='#URL.Modules#'
  14.     ORDER BY Log.Status;
  15. </CFQUERY>
  16.  
  17. <table width="580" border="2" cellspacing="2" cellpadding="2">
  18.   <tr>
  19.     <CFOUTPUT>
  20.     <td colspan=2><b>Comments regarding '#URL.Modules#'.</b></td>
  21.     </cfoutput>
  22.   </tr>
  23. <CFIF GetComments.RecordCount IS "0">
  24.   <tr>
  25.     <td colspan=2> No records match your search criteria. <BR></td>
  26.   </tr>
  27. <CFELSE>
  28.  
  29. <CFOUTPUT query="GetComments"><CFFORM NAME="Form1" ACTION="updatecomment.cfm" TARGET="updatecomment" METHOD="Post">
  30. <tr>
  31.     <td colspan=2><b>Comment '#ID#'</b></td>
  32.   </tr>
  33.   <tr>
  34.     <td width="150" valign="top"> 
  35.       <p><b><font color="BLUE">Source:</font></b><BR>
  36.         #Source# <br>
  37.         <b><font color="BLUE">Type:</font></b><br>
  38.         #Type# <br>
  39.         <b><font color="BLUE">Urgency:</font></b><br>
  40.         #Urgency# <br>
  41.         <b><font color="BLUE">Status:</font></b><br>
  42.         #Status# <br>
  43.         <b><font color="BLUE">Person Responsible:</font></b><br>
  44.         #Person_Responsible# <br>
  45.         <b><font color="BLUE">Date Entered:</font></b><br>
  46.         #Date_Entered# <br>
  47.         <b><font color="BLUE">Date Closed:</font></b><br>
  48.         #Date_Closed# </p>
  49.       </td>
  50.     <td width="408" valign="top"> 
  51.       <p><b><font color="BLUE">Content Area:</font></b> #Content_Area#<br>
  52.         <b><font color="BLUE">Feedback Point:</font></b><br>
  53.         #Feedback_Point#<br>
  54.         <b><font color="BLUE">Notes:</font></b><br>
  55.         <TEXTAREA NAME="Notes" COLS=50 ROWS=5>#Notes#</TEXTAREA>
  56.         <b><font color="BLUE">Resolution:</font></b><br>
  57.         #Resolution# 
  58.         </p>  
  59.         <INPUT TYPE="Hidden" NAME="ID" VALUE="#ID#"><BR>
  60.         <INPUT TYPE="Submit" VALUE="Update Information"> 
  61.       </td>
  62.   </tr>    
  63. </CFFORM></CFOUTPUT>
  64.  
  65. </CFIF>
  66. </table>
  67.  
  68. </body>
  69. </html>
  70.  
  71.  
  72.  
  73.  
  74.  
  75.  
  76.  
  77.