<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&ouml;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&ouml;schen">
    </FORM>
  </BODY>
</HTML>