home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / viewdtl.cfm < prev    next >
Text File  |  1998-02-10  |  1KB  |  58 lines
  1. <!------------------------└╔ªWíGViewdetl.cfm----------------------->
  2. <!---        Ñ╗└╔¼O▒Ndetail╝╞╛┌¬φñ║¬║░O┐²º╣Ñ■┼πÑ▄ÑX¿╙    --->
  3. <!----------------------------------------------------------------->
  4.  
  5.  
  6.  
  7. <HTML>
  8. <HEAD>
  9. <TITLE>¡q│µªC¬φ</TITLE>
  10.  
  11. </HEAD>
  12.  
  13. <BODY background="paper12l.jpg">
  14. <H2 align="center">¡q│µ▓╙╕`ªC¬φ<br>
  15. <hr>
  16. <TABLE BORDER="1" ALIGN="center" WIDTH="75%">
  17. <TR>
  18. <TD align="left">¡q│µ╜s╕╣</TD>
  19. <TD align="left">│f¬½╜s╕╣</TD>
  20. <TD align="left">│f¬½ªW║┘</TD>
  21. <TD align="left">╝╞╢q</TD>
  22. </TR>
  23.  
  24. <!---▓─ñGªµ╢}⌐l--->
  25.  
  26.     <cfquery name="GetRecord" datasource = "Dynamic Database">
  27.         select     detail.order_id, 
  28.             detail.quantity, 
  29.             detail.prod_id,
  30.             product.product_name
  31.         from     detail, 
  32.             product
  33.         where     detail.prod_id=product.prod_id
  34.     </cfquery>
  35.  
  36.  
  37.  
  38. <cfset totalrec=0>
  39.     <cfoutput query="GetRecord">
  40.     <TR>
  41.         <TD align="left">#order_id#</TD>
  42.         <TD align="left">#prod_id#</TD>
  43.         <TD align="left">#product_name#</TD>
  44.         <TD align="left">#quantity#</TD>
  45.     </TR>    
  46.     </cfoutput>
  47.  
  48. </TABLE>
  49. <hr>
  50.     ░O┐²┴`╝╞íG    <cfoutput>
  51.             <cfset totalrec=#GetRecord.recordcount#>    
  52.             #totalrec#
  53.             </cfoutput>
  54.  
  55. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  56. </body>
  57. </html>
  58.