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