home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / query1.cfm < prev    next >
Text File  |  1997-09-09  |  442b  |  20 lines

  1.     <!--- Database Query ---> 
  2.     <CFQUERY NAME="ProductList" DATASOURCE="dynamic database">
  3.     SELECT * FROM product
  4.     </CFQUERY>
  5.  
  6.     <HTML>
  7.     <HEAD>
  8.     <TITLE>Product List</TITLE>
  9.     </HEAD>
  10.  
  11.     <BODY>
  12.     <H2>Product List</H2>
  13.     <HR>
  14.     <!--- Output of database Query --->
  15.     <CFOUTPUT QUERY="ProductList">
  16.     #prod_id#</B> #Product_name#</b> #type#</b>#cost#<BR>
  17.     </CFOUTPUT>
  18.     </BODY>
  19.     </HTML> 
  20.