<% response.write "Test String" set con = server.CreateObject("ADODB.Connection") con.open "Driver={Microsoft Access Driver(*.mdb);DBQ=" & Server.MapPath("PG.MDB") 'con.open "DRIVER={Mysql}; Server=209.62.87.247; Database=peoplesdb; UID=peoplesgdb; PWD=abc123$it;" set rs = Server.CreateObject("ADODB.Recordset") rs.open "Select top 10 * from jobpost order by sno desc", con rs.pagesize = 10 %> People's Group :: Current Opening



  

 
 
<% dim recordcount recordcount = 0 if not rs.eof then do while ((not rs.eof) And (recordcount < rs.pagesize)) sno=rs("sno") code = rs("jobcode") unit = rs("unitname") post = rs("post") skill = rs("Skills") expe = rs("experience") openingdate = rs("openingdate") %> <% recordcount = recordcount+1 rs.movenext loop end if set rs = nothing %>
CURRENT OPENING ::
Opening Date Unit Name Post Experience
<% =openingdate%> <% =unit%> <% =post%> <% = expe%>
Home  | About Us  | Campus Tour  | Careers  | Feedback  | Contact Us  | Site Map  | Disclaimer 
Site Designed & Maintained by IT Department, People's Group (India) © Copyright 2005,
This site is best viewed in IE 5.0 and above with a 800x600 monitor resolution