<CFQUERY NAME       = "Studentenliste"
         USERNAME   = "erika"
         PASSWORD   = "mustermann"
         DATASOURCE = "dbs" 
         DBTYPE     = "ODBC">
  SELECT matrnr, name from studenten
</CFQUERY>

<HTML>
  <HEAD>
    <TITLE> Studentenliste </TITLE>
  </HEAD>
  <BODY>
    <H2> Studentenliste (unformatiert)</H2>
    <CFOUTPUT QUERY="Studentenliste">
      #name# #matrnr# <BR>
    </CFOUTPUT>
  </BODY>
</HTML>