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