home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Cool Page Magazine 16
/
CoolPage_16.iso
/
dynadb
/
codes
/
viewprod.cfm
< prev
Wrap
Text File
|
1997-12-03
|
1KB
|
56 lines
<!------------------------└╔ªWíGProdlist.cfm----------------------->
<!--- Ñ╗└╔¼O▒NProduct╝╞╛┌¬φñ║¬║░O┐²º╣Ñ■┼πÑ▄ÑX¿╙ --->
<!----------------------------------------------------------------->
<HTML>
<HEAD>
<TITLE>Product Listing</TITLE>
</HEAD>
<BODY background="paper12l.jpg">
<H2>│f½~▓M│µ<br>
<TABLE BORDER="3" ALIGN="DEFAULT" WIDTH="100%">
<!---▓─ñ@ªµ--->
<TR>
<TD align="left">│f½~╜s╕╣</TD>
<TD align="left">│f½~ªW║┘</TD>
<TD align="left">╝╞╢q</TD>
<TD align="left">╗∙«µ</TD>
<TD align="left">║╪├■</TD>
</TR>
<cfquery name="productlist" datasource = "Dynamic Database">
select * from product
</cfquery>
<cfset totalrec=0>
<cfloop query="productlist">
<cfset totalrec=#productlist.recordcount#>
<cfoutput>
<cfset outid=#type#>
<TR>
<TD align="left">#prod_id#</TD>
<TD align="left">#product_name#</TD>
<TD align="right">#quantity#</TD>
<TD align="right">#cost#</TD>
</cfoutput>
<cfquery name="GetType" datasource="Dynamic Database">
select * from prodtype where type_code='#outid#'
</cfquery>
<TD align="left"><cfoutput query="GetType">#type_name#</cfoutput></TD>
</TR>
</cfloop>
</TABLE>
<hr>
░O┐²┴`╝╞íG<cfoutput>#totalrec#</cfoutput>
<P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
</body>
</html>