home *** CD-ROM | disk | FTP | other *** search
- <CFIF Server.OS.Name IS NOT "UNIX">
- <!-- Lookup department name -->
- <CFQUERY Name="Department" DataSource="cfsnippets">
- SELECT Dept_Name FROM Departments
- WHERE Dept_ID = '#Form.Department#'
- </CFQUERY>
-
- <!-- Get courses offered by department -->
- <CFQUERY Name="Courses" DataSource="cfsnippets">
- SELECT * FROM CourseList
- WHERE Dept_ID = '#Form.Department#'
- </CFQUERY>
- <CFELSE>
- <!-- Lookup department name -->
- <CFQUERY Name="Department" DataSource="cfsnippets">
- SELECT Dept_Name FROM Departments
- WHERE Dept_ID = '#Form.Department#'
- </CFQUERY>
-
- <!-- Get courses offered by department -->
- <CFQUERY Name="Courses" DataSource="cfsnippets">
- SELECT * FROM CourseList
- WHERE Dept_ID = '#Form.Department#'
- </CFQUERY>
- </CFIF>
-
- <HTML>
- <HEAD><TITLE>ColdFusion University Course Search</TITLE>
- </HEAD>
- <script language="Javascript">
-
- var DocRemote = 0;
-
- function makeRemote(){
-
- if(DocRemote){
- if(DocRemote.closed){
- DocRemote = 0;
- makeRemote();
- }else{
- DocRemote.focus();
- }
- }else{
- DocRemote = window.open('../search.cfm',
- 'Search',
- 'scrollbars,resizable,width=510,height=300');
- }
- }
-
- </script>
-
- <script language="JavaScript1.1">
-
- blank = new Image();
- blank.src = '../images/mouseovers/blank.gif';
-
- imgBack = new Image();
- imgBack.src = '../images/mouseovers/back.gif';
-
- imgSearch = new Image();
- imgSearch.src = '../images/mouseovers/search.gif';
-
- imgTop = new Image();
- imgTop.src = '../images/mouseovers/toplevel.gif';
-
- imgUp = new Image();
- imgUp.src = '../images/mouseovers/uplevel.gif';
-
- imgNext = new Image();
- imgNext.src = '../images/mouseovers/next.gif';
-
- </script>
- </head>
-
- <body background="../images/bgblue.gif" bgcolor="#99CC99" text="#333333" vlink="#669966">
- <basefont size=2 face="Arial, Helvetica">
- <center>
- <table width="600" border="0" cellspacing="0" cellpadding="2" bgcolor="#000066">
- <tr><td><font face="arial, geneva, helvetica, sans serif" size=0 color=white><a name="top"></a>
-
- <table border="0" cellspacing="0" cellpadding="0" bgcolor="white" width=600>
-
- <tr> <!--- 7 cols. Col 7 = color only --->
- <td width=50 nowrap bgcolor="000066"></td>
- <td width=25 nowrap bgcolor="000066"></td>
- <td width=25 nowrap bgcolor="000066"></td>
- <td width=425 nowrap bgcolor="000066"></td>
- <td width=50 nowrap bgcolor="000066"></td>
- <td width=13 nowrap bgcolor="000066"></td>
- <td width=2 nowrap rowspan=99 bgcolor=336633> </td>
- </tr>
-
- <tr>
- <td colspan=1> </td>
- <td colspan=5 height=25 align=right valign="top">
- <!--- Navbar --->
- <table border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td valign=top>
- <img src="../images/mouseovers/blank.gif" name="DescText" width=157 height=33 border=0><br>
- </td>
- <td valign=top>
- <a href="./test.htm" OnMouseOut="DescText.src=blank.src" OnMouseOver="DescText.src=imgBack.src"><img src="../images/navwidgets/back.gif" width=80 height=33 border=0></a><br>
- </td>
- <td>
- <a href="javascript: makeRemote();" OnMouseOut="DescText.src=blank.src" OnMouseOver="DescText.src=imgSearch.src"><img src="../images/navwidgets/search.gif" width=39 height=33 border=0></a><br>
- </td>
- <td>
- <a href="./test.htm" OnMouseOut="DescText.src=blank.src" OnMouseOver="DescText.src=imgUp.src"><img src="../images/navwidgets/up.gif" width=41 height=33 border=0></a><br>
- </td>
- <td>
- <img src="../images/navwidgets/next.gif" width=40 height=33 border=0><br>
- </td>
- </tr>
- </table>
-
- </td>
- </tr>
-
- <tr>
- <td height=75 bgcolor=ffFFff colspan=5> </td>
- <td rowspan=99 bgcolor=339933> </td> <!--- Col 6 = color only (Col 7 is color only too) --->
- </tr>
-
- <tr>
- <td bgcolor=ffFFff> </td>
- <td bgcolor=ffFFff> </td>
- <td align="right" bgcolor=ffFFff colspan=2><img src="../images/welcomecover/allaire.gif" width="177" height="25" hspace="25" border="0" alt="allaire">
- <br>
- <br>
-
- </td>
- <td bgcolor=ffFFff> </td>
- </tr> <!-- End previous row --->
- <tr>
- <td colspan=1 bgcolor=ffFFff> </td>
- <td colspan=3 bgcolor=ffFFff>
- <font face="Arial Black, Helvetica" size="+2">Verify Installation and Configuration</font>
- </td>
- <td bgcolor=ffFFff> </td>
- </tr>
-
- <tr><td height=8 bgcolor=ffFFff colspan=5> </td></tr>
-
- <tr>
- <td colspan=2 bgcolor=ffFFff> </td>
- <td colspan=2 bgcolor=ffFFff>
- <font face="Arial Black, Helvetica" size="+1">Test Query Results</font>
- </td>
- <td bgcolor=ffFFff> </td>
- </tr>
- <!--- Put some space between heading and body --->
- <tr><td height=8 bgcolor=ffFFff colspan=5> </td></tr>
-
- <tr>
- <td colspan=3 bgcolor=ffFFff> </td>
- <td bgcolor=ffFFff>
- <font face="Arial, Helvetica">
- <!-- Banner for department name -->
- <CFIF Server.OS.Name IS NOT "UNIX">
- <CFOUTPUT Query="Department">
- <H3>Courses Offered by the #Dept_Name# Department</H3>
- </CFOUTPUT>
- </font>
-
- <!-- Table displaying courses offered -->
- <CFTABLE Query="Courses" HTMLTABLE BORDER COLHEADERS MAXROWS=200 >
- <CFCOL Header="<B>Number</B>" Width=10 Text="#CorNumber#">
- <CFCOL Header="<B>Course Name</B>" Width=25 Text="#CorName#">
- <CFCOL Header="<B>Level</B>" Width=15 Align=Right Text="#CorLevel#">
- </CFTABLE>
-
- <CFELSE>
- <font face="Arial, Helvetica">
- <CFOUTPUT Query="Department">
- <H3>Courses Offered by the #Dept_Name# Department</H3>
- </CFOUTPUT>
- </font>
- <!-- Table displaying courses offered -->
- <CFTABLE Query="Courses" HTMLTABLE BORDER COLHEADERS MAXROWS=200>
- <CFCOL Header="<B>Number</B>" Width=10 Text="#Trim(CorNumber)#">
- <CFCOL Header="<B>Course Name</B>" Width=25 Text="#Trim(CorName)#">
- <CFCOL Header="<B>Level</B>" Width=15 Align=Right Text="#Trim(CorLevel)#">
- </CFTABLE>
- </CFIF>
- <BR>
- <font face="Arial, Helvetica">
- <P>
- ColdFusion has been correctly installed and configured to work
- with your Web server.
-
- <P>
- Now that everything has been set up properly, you probably want
- to learn about all of the things you can do with ColdFusion. The
- <a href="../examplehome.htm">Example Applications</a>
- page has pointers to several resources to help you get started.
- </font>
- </TD>
- <td bgcolor=ffFFff> </td>
- </TR>
-
- <tr><td height=100 colspan=5 bgcolor=ffFFff> </td></tr>
- <tr>
- <td colspan=4 align=right bgcolor=ffFFff>
- <a href="./test.htm"><img src="../images/navwidgets/lowerback.gif" WIDTH=50 HEIGHT=31 border=0 alt="Back"></a><a href="./test.htm"><img src="../images/navwidgets/lowertop.gif" alt="Up Level" WIDTH=41 HEIGHT=31 border=0></a><img src="../images/navwidgets/lowernext.gif" alt="Next" WIDTH=50 HEIGHT=31 border=0><br>
- </td>
- <td bgcolor=ffFFff> </td>
- </tr>
- <tr><td height=120 colspan=5 bgcolor=ffFFff> </td></tr>
- <tr>
- <td colspan=5 height=29 valign=top>
- <font size="-2" face="Arial, Helvetica">
- <p>
- <a href="http://www.allaire.com"><img src="../images/navwidgets/allaireblue.gif" width=230 border=0 hspace=0 vspace=0 height=29 align="left" alt="allaire"></a>
- <a href="mailto:allairedoc@allaire.com">AllaireDoc@allaire.com</a><br>
- Copyright © 1998, Allaire Corporation. All rights reserved.<br>
- </font>
- </td>
- </tr>
-
- </table>
- </td>
- </tr>
- </table>
-
-
- </BODY>
- </HTML>
-