<CFQUERY NAME = "Professorentabelle"
USERNAME = "erika" PASSWORD = "mustermann"
DATASOURCE = "dbs" DBTYPE = "ODBC">
SELECT * from professoren
</CFQUERY>
<HTML>
<HEAD>
<TITLE> Professorenformular zum L&oum;schen </TITLE>
</HEAD>
<BODY>
<H2> Professorenformular zum Löschen</H2>
<TABLE BORDER>
<TD>PersNr</TD><TD>Name</TD><TD>Rang</TD><TD>Raum</TD></TR>
<CFOUTPUT QUERY="Professorentabelle">
<TR><TD>#persnr#</TD><TD>#name#</TD><TD>#rang#</TD><TD>#raum#</TD></TR>
</CFOUTPUT>
</TABLE>
<FORM ACTION="profdelete.cfm" METHOD="POST">
Personalnummer: <INPUT SIZE=4 TYPE="text" NAME="Persnr">
<INPUT TYPE="Submit" VALUE="Datensatz löschen">
</FORM>
</BODY>
</HTML>