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