Student Center

<% 'on error resume next ' ################################################################################## ' CONSTANTS ' file system object fsoForReading = 1 fsoForWriting = 2 fsoForAppending = 8 MSSQLDB = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&request.servervariables("APPL_PHYSICAL_PATH")&"\okwater\Poster_Abstracts.mdb" ' ################################################################################## ' FUNCTIONS function replaceSingleQuotes(thisString) tempStr = replace(thisString,"'","''") 'tempStr = replace(tempStr,'"','""') replaceSingleQuotes = tempStr end function ' ################################################################################## ' MAIN ' open database connection set conn = createobject("adodb.connection") conn.open MSSQLDB ' create the recordset to store the data set rs = server.CreateObject("ADODB.Recordset") set rs.activeconnection=conn ' get information sql = "SELECT * FROM current students order by lastname ASC" rs.source = sql rs.locktype = 3 rs.cursortype = adOpenKeyset rs.open %> Student Center

Environmental Science Graduate Program Resource Center

• Forum Login • Current Students • Posters • Publications • Awards • Research •
• Student Survey • Conferences • Fellowships • Commuter Information •

Get the latest news! Click here to open a PDF version of the ES newsletter.

If you don't have Adobe Acrobat Reader, click here.
Society of Environmental Scientists
Past Newsletters:
Fall 2007le://mswebasp/environ.okstate.edu$/ES/PDF/Fall 07 newsletter.pdf
Spring 2007
Fall 2006
Fall 2005

• Program Info • Specializations • Admission • Administration • Environmental Faculty
• ES News • Awards • Career Center • Alumni Association • Internship Info
• Degree Checklists • ES Rules • Contact Us • EI Home • ES Home • Portal