T R A I N I N G
<% If(isempty(request.querystring("action"))) then %>
HOME
Check out the available courses offered at HRM Consulting Technology.
CONSULTING
Training Main Menu
PLACEMENT

CONTACT US
ABOUT US

SEND EMAIL
<% elseif(request.querystring("action")="searchform") then %>
please enter course information to search
Search by Course Title
Search by Course Category

<% elseif (request.querystring("action")="search") then %>

search results:

<% set ocon = _ server.createobject("adodb.connection") ocon.open "ruzidsn" Usersearchchoice = cstr (request.querystring("searchwhat")) select case usersearchchoice case "course" usercourse = _ cstr (request.querystring("course")) set currentrecordset = _ ocon.execute("select * from courses where course like '%" & _ usercourse & "%'") Case "course_description" usercourse_description = _ cstr (request.querystring("course_description")) set currentrecordset = _ ocon.execute("select * from courses where course_description like '%" & usercourse_description & "%'") end select If currentrecordset.EOF then %>

no matching records found

<%else currentrecordset.movefirst %>
<% do while not currentrecordset.EOF response.write ("") currentrecordset.movenext loop %>

Course

 Course Description Cost Start Date End Date
") response.write (currentrecordset.fields("course")) response.write ("") response.write (currentrecordset.fields("course_description")) response.write ("") response.write (currentrecordset.fields("cost")) response.write ("") response.write (currentrecordset.fields("start_date")) response.write ("") response.write (currentrecordset.fields("end_date")) response.write ("

<% end if %>

<% elseif(request.querystring("action")="view") then set ocon=_ server.createobject("adodb.connection") ocon.open "ruzidsn" set ors=ocon.execute("select * from courses") ors.movefirst%>

List of all Courses offered at HRM Technology

<% Do while not ors.EOF response.write("") ors.movenext loop %>
Courses Course Description Cost Starting Date End Date
") response.write(ors.fields("course")) response.write("") response.write(ors.fields("course_description")) response.write("") response.write(ors.fields("cost")) response.write("") response.write(ors.fields("start_date")) response.write("") response.write(ors.fields("end_date")) response.write("") response.write("

VISIT OTHER PAGES
[VB] [C/UNIX] [C++] [DATABASE] [INTERNET]
[HOME] [CONSULTING] [PLACEMENT] [ABOUT_US] [CONTACT_US] [EMAIL]
<%else%>

the selection you made is not valid selection!

<%end if%>