home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / typelist.cfm < prev    next >
Text File  |  1997-12-03  |  908b  |  38 lines
  1. <!------------------------└╔ªWíGTypelist.cfm----------------------->
  2. <!---        Ñ╗└╔¼O▒NProdtype╝╞╛┌¬φñ║¬║░O┐²º╣Ñ■┼πÑ▄ÑX¿╙    --->
  3. <!----------------------------------------------------------------->
  4.  
  5. <cfquery name="typelist" datasource = "Dynamic Database">
  6.     select * from prodtype
  7. </cfquery>
  8.  
  9. <HTML>
  10. <HEAD>
  11. <TITLE>│f¬½║╪├■ªC¬φ</TITLE>
  12.  
  13. </HEAD>
  14.  
  15. <BODY background="paper12l.jpg">
  16. <H2 align="center">│f¬½║╪├■ªC¬φ<br>
  17. <hr>
  18. <TABLE BORDER="1" ALIGN="center" WIDTH="75%">
  19.  
  20. <TR>
  21. <TD align="left">║╪├■╜s╕╣</TD>
  22. <TD align="left">║╪├■ªW║┘</TD>
  23. </TR>
  24.  
  25. <!---▓─ñGªµ╢}⌐l--->
  26. <cfset totalrec=0>
  27. <cfoutput query="typelist">
  28.     <TR><TD align="left">#type_code#</TD>
  29.     <TD align="left">#type_name#</TD></TR>
  30.     <cfset totalrec=#typelist.recordcount#>    
  31. </cfoutput>
  32. </TABLE>
  33. <hr>
  34.     ░O┐²┴`╝╞íG<cfoutput>#totalrec#</cfoutput>
  35.  
  36. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  37. </body>
  38. </html>