home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / prodlista.cfm < prev    next >
Text File  |  1997-12-01  |  1KB  |  48 lines
  1. <!------------------------└╔ªWíGProdlist.cfm----------------------->
  2. <!---        Ñ╗└╔¼O▒NProduct╝╞╛┌¬φñ║¬║░O┐²º╣Ñ■┼πÑ▄ÑX¿╙    --->
  3. <!----------------------------------------------------------------->
  4.  
  5. <HTML>
  6. <HEAD>
  7. <TITLE>Product Listing</TITLE>
  8. </HEAD>
  9.  
  10. <BODY>
  11. <H2>The following is the listing of products<br>
  12.  
  13. <TABLE BORDER="0" ALIGN="DEFAULT" WIDTH="100%">
  14. <!---▓─ñ@ªµ--->
  15. <TR>
  16. <TD align="center">Product No</TD>
  17. <TD align="center">Product Name</TD>
  18. <TD align="center">Product Type</TD>
  19. <TD align="center">Quantity</TD>
  20. <TD align="Cost">Cost</TD>
  21. </TR>
  22.  
  23. <cfquery name="productlist" datasource = "Dynamic Database">
  24.     select * from product
  25. </cfquery>
  26.  
  27. <cfloop query="productlist">
  28.     <cfoutput>
  29.         <cfset outid=#type#>
  30.         <TR>                
  31.         <TD align="left">#prod_id#</TD>
  32.         <TD align="left">#product_name#</TD>
  33.         <TD align="right">#quantity#</TD>
  34.         <TD align="right">#cost#</TD>
  35.     </cfoutput>
  36.  
  37.     <cfquery name="GetType" datasource="Dynamic Database">
  38.         select * from prodtype where type_code='#outid#'
  39.     </cfquery>
  40.     
  41.     <TD align="center"><cfoutput query="GetType">#type_name#</cfoutput></TD>
  42.     </TR>
  43. </cfloop>
  44. </TABLE>
  45. <hr>
  46. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  47. </body>
  48. </html>