Example Code
Click on any line of code that has a gray background to get a description of what the code means. To print the description, use the menu bar across the top of the small window and select the
Print
option found under
File
.
<html>
<head>
<title>Student Information</title>
<meta name="Microsoft Theme" content="construc 001, default">
<meta name="Microsoft Border" content="tlb, default">
</head>
<body>
<h3>Information About - </h3>
<%
'HERE'S YOUR SQL STATEMENT
'EXECUTE YOUR SQL STATEMENT
%>
'PROVIDE MESSAGE IF NO MATCH WAS FOUND.
<%
%>
<%
'EXECUTE IT (DISPLAY ALL MATCHED RECORDS)UNTIL YOU REACH THE END OF THE FILE.
'WRITE THE INFORMATION YOU GOT FROM THE DATABASE ON THE SCREEN
& dbRs.Fields("School1") & ", " & dbRs.Fields("School1_Town") & "<br>" & "<b>Cooperating Teacher: </b>" & dbRs.Fields("School1_coop") & "<br>" & "<br>" & "<b>Second School: </b>" & dbRs.Fields("School2") & ", " & dbRs.Fields("School2_Town") & "<br>" & "<b>Cooperating Teacher: </b>" & dbRs.Fields("School2_coop") & "<br>" & "<br>" & "<b>Email Address: </b>" & dbRs.Fields("Email") & "<p>"
'MOVE TO THE NEXT RECORD
'CLOSE THE DATABASE
%>
<h3><a href="members.asp#Inquiry Form:">Return to Members Page</a></h3>
</body>
</html>