Source of ColdFusion/studsuche.cfm

<CFQUERY NAME       = "Studentensuche"
         USERNAME   = "erika"
         PASSWORD   = "mustermann"
         DATASOURCE = "dbs"         
         DBTYPE     = "ODBC" >
  SELECT distinct s.matrnr, s.name 
  FROM   professoren p, vorlesungen v, hoeren h, studenten s
  WHERE  s.matrnr     = h.matrnr
  AND    h.vorlnr     = v.vorlnr
  AND    v.gelesenvon = p.persnr
  AND    p.name       = '#FORM.Profname#'
</CFQUERY>

<HTML>
  <HEAD>
    <TITLE> Studenten eines Professors </TITLE>
  </HEAD>
  <BODY>
    <CFOUTPUT>
      Professor #FORM.Profname# hat folgende H&ouml;rer: <P>
    </CFOUTPUT>
    <CFOUTPUT QUERY="Studentensuche">
      #matrnr# #name#<BR>
    </CFOUTPUT>
  </BODY>
</HTML>