home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / viewprod.cfm < prev   
Text File  |  1997-12-03  |  1KB  |  56 lines

  1. <!------------------------└╔ªWíGProdlist.cfm----------------------->
  2. <!---        Ñ╗└╔¼O▒NProduct╝╞╛┌¬φñ║¬║░O┐²º╣Ñ■┼πÑ▄ÑX¿╙    --->
  3. <!----------------------------------------------------------------->
  4.  
  5. <HTML>
  6. <HEAD>
  7.  
  8. <TITLE>Product Listing</TITLE>
  9. </HEAD>
  10.  
  11. <BODY background="paper12l.jpg">
  12. <H2>│f½~▓M│µ<br>
  13.  
  14. <TABLE BORDER="3" ALIGN="DEFAULT" WIDTH="100%">
  15. <!---▓─ñ@ªµ--->
  16. <TR>
  17. <TD align="left">│f½~╜s╕╣</TD>
  18. <TD align="left">│f½~ªW║┘</TD>
  19. <TD align="left">╝╞╢q</TD>
  20. <TD align="left">╗∙«µ</TD>
  21. <TD align="left">║╪├■</TD>
  22. </TR>
  23.  
  24.  
  25.  
  26.  
  27.  
  28.  
  29. <cfquery name="productlist" datasource = "Dynamic Database">
  30.     select * from product
  31. </cfquery>
  32. <cfset totalrec=0>
  33. <cfloop query="productlist">
  34. <cfset totalrec=#productlist.recordcount#>    
  35.     <cfoutput>
  36.         <cfset outid=#type#>
  37.         <TR>                
  38.         <TD align="left">#prod_id#</TD>
  39.         <TD align="left">#product_name#</TD>
  40.         <TD align="right">#quantity#</TD>
  41.         <TD align="right">#cost#</TD>
  42.     </cfoutput>
  43.  
  44.     <cfquery name="GetType" datasource="Dynamic Database">
  45.         select * from prodtype where type_code='#outid#'
  46.     </cfquery>
  47.     
  48.     <TD align="left"><cfoutput query="GetType">#type_name#</cfoutput></TD>
  49.     </TR>
  50. </cfloop>
  51. </TABLE>
  52. <hr>
  53.     ░O┐²┴`╝╞íG<cfoutput>#totalrec#</cfoutput>
  54. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  55. </body>
  56. </html>