home *** CD-ROM | disk | FTP | other *** search
- <!--- This CFQUERY retrieves the categories from the database --->
- <CFQUERY DATASOURCE="CFexamples" NAME="GetCategories">
- SELECT CategoryID, CategoryName, CategoryDesc FROM StoreCategories
- </CFQUERY>
-
- <HTML>
- <HEAD>
- <TITLE>Online Store - Choose Category</TITLE>
- </HEAD>
-
- <BODY BGCOLOR="FFcc33" BACKGROUND="images/storebg.gif" LEFTMARGIN=5 TOPMARGIN=0>
-
- <SPAN STYLE="position: absolute; left: 220px; top: 30px">
- <img src="images/cover_store.jpg" width=300 height=335 alt="" border="0" vspace="0" hspace="0">
- </SPAN>
-
-
- <SPAN STYLE="position: absolute; left: 145px; top: 45px">
- <IMG SRC="images/tack2.gif" WIDTH=249 HEIGHT=58 BORDER=0 ALT="TACK2">
- </SPAN>
-
- <SPAN STYLE="position: absolute; left: 200px; width: 350px; top: 380px">
- <!--- This CFOUTPUT block loops over the GetCategories query
- and creates the following HTML for each one. --->
- <TABLE BORDER="0" CELLPADDING="5" CELLSPACING="0" WIDTH="350">
-
- <CFOUTPUT QUERY="GetCategories">
-
- <FORM ACTION="showitems.cfm" METHOD="GET">
-
- <!--- This form variable tells showitems.cfm which
- category to get items from --->
- <INPUT TYPE="HIDDEN" NAME="CategoryID" VALUE="#CategoryID#">
-
- <TR>
- <TD><FONT FACE="Arial Black, Helvetica Bold, Geneva, Helvetica" SIZE="5" COLOR="##000000"><I>#CategoryName#</I></FONT></TD>
- <TD ALIGN="RIGHT"><FONT FACE="Helvetica" SIZE="-1"><INPUT TYPE="SUBMIT" VALUE="Browse"></FONT></TD>
- </TR>
- <TR>
- <TD COLSPAN="2"><FONT FACE="Helvetica" SIZE="-1">#CategoryDesc#</FONT></TD>
- </TR>
- <TR>
- <TD HEIGHT="15"> </TD>
- </TR>
-
- </FORM>
-
- </CFOUTPUT>
-
- <TR>
- <TD HEIGHT="50"> </TD>
- </TR>
-
- </TABLE>
-
- <CF_SHOWDOC ID=1>
-
- </SPAN>
-
- <CFINCLUDE TEMPLATE="_showcart.cfm">
-
- </BODY>
- </HTML>
-