<% Set cn = Server.CreateObject("adodb.connection") set rs = server.CreateObject("adodb.recordset") cn.Open "DSN=swim;UID=;PWD=;Database=seminar" sql = "select a.course_title, a.course_location, a.course_dates, a.course_startdate, b.session_description, a.instructor_name " sql = sql & "from fa_courses a, fa_sessions b " sql = sql & "where a.course_session = b.course_session " sql = sql & "and a.course_display_fromdate <= getDate() " sql = sql & "and a.course_display_todate >= getDate() " sql = sql & "order by b.course_session, a.course_startdate" rs.open sql,cn,0,1 if not rs.eof then course_num=0 session_desc="" title="Course Title" location="Location" instructor="Instructor Bio" %>
| <%=rs("session_description")%>Fall Session / Section 1 | <%=title%> Embassy Suites Hotel | |
| Course <%=course_num%>1: Friday, October 10 | Forensic Accounting & Legal Elements of Fraud | Registration 8 - 8:30 a.m. Class: 8:30 - 5 p.m. |
| Course <%=course_num%>2: Friday, October 17 | Fraud Examination | Registration 8 - 8:30 a.m. Class: 8:30 - 5 p.m. |
| Course <%=course_num%>3: Friday, October 31 | Fraud Investigation Techniques | Registration 8 - 8:30 a.m. Class: 8:30 - 5 p.m. |
| Course <%=course_num%>4: Friday, November 7 | Fundamentals of Computer Fraud & Investigation | Registration 8 - 8:30 a.m. Class: 8:30 - 5 p.m. |