CSCI 4230.1
Software Tools
Spring 1999
Suggested Solution to Final Examination




(1)    For example:

<body bgcolor="#CCCCFF">
<center>
<h3> Special Characters in HTML using &#38;#:</h3>
<script language="JavaScript">
<!-- Begin
document.write('<table border=2 cellpadding=2>');
document.write('<tr><td><strong>Number</strong></td><td><strong>Character</strong></td></tr>');
for(var count=33; count<255; count++) {
    document.write('<tr><td align=center>&#38;#' + count+ ';</td><td align=center>'+'&#'+count+';</td></tr>');
}
document.write('</table>');

// End Script -->
</script>
</center>
</body>

(2)    For example:

<body bgcolor=#CCFFCC>
<CFSET CountryFirstChar = URL.CountryFirstChar>
<CFQUERY NAME="StudentQuery" DATASOURCE="yue">
     select country, name, email
     from s99t2alt_student
     where Country like '#CountryFirstChar#%'
     order by country
</CFQUERY>

<h2 style="color:blue">Students by Country</h2>
<p>

<table border=1>
<CFSET PrevCountry = "">
<CFLOOP QUERY="StudentQuery">
   <CFIF NOT PrevCountry IS StudentQuery.country>
      <CFOUTPUT>
         <TR><TD width=80 valign=top>#StudentQuery.country#
             <TD width=240><A HREF="mailto:#StudentQuery.Email#">#StudentQuery.Name#</A>
      </CFOUTPUT>
      <CFSET PrevCountry = StudentQuery.country>
   <CFELSE>
      <CFOUTPUT>, <A HREF="mailto:#StudentQuery.Email#">#StudentQuery.Name#</A></CFOUTPUT>
   </CFIF>
</CFLOOP>
</table>
</body>

(3)    (a)

<?xml version="1.0" ?>
<?xml-stylesheet href="t2aq3.css" type="text/css" ?>
<!DOCTYPE t2aq3 SYSTEM "t2aq3.dtd">

<chapter>
   <author name="yue" gender="male" />
   <title>Cold Fusion</title>
   <para>
         Cold Fusion is a server-side technology.
         <sidenote>Cold Fusion Files ends with the file extension .cfm.</sidenote>
        <sidenote>Cold Fusion is a product of Allaire Corp.</sidenote>
   </para>
   <para>
         Cold Fusion tag starts with a "CF".  For example, &lt;CFOUTPUT&gt;.
   </para>
</chapter>

(b)    For example:

<?xml encoding="UTF-8"?>
<!ELEMENT chapter (author, title, para*)>
<!ELEMENT author EMPTY>
<!ATTLIST author name CDATA #IMPLIED
                 gender (male|female) #IMPLIED>
<!ELEMENT title (#PCDATA)>
<!ELEMENT para (#PCDATA|sidenote)*>
<!ELEMENT sidenote (#PCDATA)>

(c)    For example:

<style>
somestyle {}
chapter {
   background-color:yellow;
   font-family:Helvetica,sans-serif;
}
title {
   font-size:200%;
}
sidenote {
   font-size:70%;
   color:blue;
}
</style>