<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>
<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>