Source of ColdFusion/vorltabelle.cfm

<CFQUERY NAME       = "Vorlesungstabelle"
         USERNAME   = "erika"      PASSWORD = "mustermann"
         DATASOURCE = "dbs"        DBTYPE   = "ODBC">
  SELECT vorlnr, titel, name, persnr FROM vorlesungen, professoren
  where gelesenvon = persnr
</CFQUERY>
<HTML>
  <HEAD> <TITLE> Vorlesungstabelle </TITLE> </HEAD>
  <BODY>
    <H2> Vorlesungen mit sensitiven Links </H2>
    <TABLE BORDER>
    <TR><TD>Vorlesungsnr</TD> <TD> Titel </TD> <TD>Dozent</TD> </TR>
    <CFOUTPUT QUERY="Vorlesungstabelle">
      <TR><TD>#vorlnr#</TD><TD>#Titel#</TD> 
      <TD><A HREF="profinfo.cfm?profid=#persnr#">#name#</A></TD></TR>
    </CFOUTPUT>
    </TABLE>
  </BODY> 
</HTML>