home *** CD-ROM | disk | FTP | other *** search
/ Using Visual Basic 5 (Platinum Edition) / vb5.iso / Code / ch39 / register.asp < prev    next >
Encoding:
Text File  |  1997-09-21  |  3.4 KB  |  129 lines
  1. <%
  2. Set Conn = Server.CreateObject("ADODB.Connection")
  3. Conn.Open "DSN=Training"
  4. SQL = "SELECT Schedule.*,Course.Title FROM Schedule,Course "
  5. SQL = SQL & "WHERE (Schedule.Course_ID = Course.ID) "
  6. SQL = SQL & "AND (Schedule.Schedule_ID="
  7. SQL = SQL & Request.QueryString("ID") & ")"
  8. Set RSSchedule = Conn.Execute(SQL)
  9. %>
  10. <html>
  11. <head>
  12. <title>Registration</title>
  13. </head>
  14. <body bgcolor="#FFFFFF">
  15. <p>
  16.      <font color="#000000" size="5" face="Verdana">
  17.           <b>Course Registration</b>
  18.      </font>
  19. </p>
  20. <form action="savereg.asp" 
  21. method="POST" 
  22. name="Course Registration">
  23.      <input type="hidden" name="Course_Date" 
  24.       value="<%=RSSchedule("Start_Date")%>">
  25.      <input type="hidden" name="Course_Name" 
  26.       value="<%=RSSchedule("Title")%>">
  27.      <table border="0">
  28.         <tr>
  29.                  <td width="80">
  30.                <strong>Date:</strong>
  31.           </td>
  32.                  <td>
  33.                <%=RSSchedule("Start_Date")%>
  34.           </td>
  35.         </tr>
  36.         <tr>
  37.                  <td width="80">
  38.                <strong>Course:</strong>
  39.                  </td>
  40.                  <td>
  41.                <%=RSSchedule("Title")%>
  42.           </td>
  43.         </tr>
  44.         <tr>
  45.                  <td width="80">
  46.                <strong>Name:</strong>
  47.           </td>
  48.                  <td>
  49.                   <input type="text" size="60" name="Name">
  50.           </td>
  51.         </tr>
  52.         <tr>
  53.                  <td width="80">
  54.                <strong>Organization:</strong>
  55.           </td>
  56.           <td>
  57.            <input type="text" size="60" name="Organization">
  58.           </td>
  59.         </tr>
  60.         <tr>
  61.                  <td>
  62.                <strong>Position:</strong>
  63.           </td>
  64.                  <td>
  65.                <input type="text" size="60" name="Position">
  66.           </td>
  67.         </tr>
  68.         <tr>
  69.                  <td>
  70.                <strong>Address:</strong>
  71.           </td>
  72.                  <td>
  73.                <input type="text" size="60" name="Address">
  74.           </td>
  75.         </tr>
  76.         <tr>
  77.                  <td>
  78.                <strong>City/Town:</strong>
  79.           </td>
  80.                  <td>
  81.                <input type="text" size="60" name="City">
  82.           </td>
  83.         </tr>
  84.         <tr>
  85.                  <td>
  86.                <strong>Postal Code:</strong>
  87.           </td>
  88.                  <td>
  89.                <input type="text" size="20" name="PostalCode">
  90.                  </td>
  91.         </tr>
  92.         <tr>
  93.             <td width="80">
  94.                <strong>Email:</strong>
  95.             </td>
  96.             <td>
  97.                <input type="text" size="60" name="EMail">
  98.             </td>
  99.         </tr>
  100.         <tr>
  101.             <td width="80">
  102.                <strong>Phone:</strong>
  103.           </td>
  104.             <td>
  105.                <input type="text" size="20" name="Phone">
  106.             </td>
  107.         </tr>
  108.         <tr>
  109.             <td width="80">
  110.                <strong>Fax:</strong>
  111.           </td>
  112.             <td>
  113.                <input type="text" size="20" name="Fax">
  114.           </td>
  115.         </tr>
  116.         <tr>
  117.             <td width="80"> </td>
  118.             <td align="right" valign="bottom">
  119.                <p align="right">
  120.                     <input type="submit"
  121.                     name="Submit Form"
  122.                     value="Submit Registration Form">
  123.                </p>
  124.             </td>
  125.         </tr>
  126.     </table>
  127. </form>
  128. </body>
  129. </html>