<% set conn=server.createobject("ADODB.Connection") 'Conn.Open "DSN=Resources; UID=webdb; PWD=webdb" 'fullsql = "SELECT * FROM Resource WHERE program = 'mentor' ORDER BY Date_Entered DESC" 'MySQL compatible 11/26/02 (GL) Conn.Open "DSN=CS; UID=webdb; PWD=webdb" fullsql = "SELECT dbo_Resource.*,rstype.ResourceType FROM dbo_Resource,rstype WHERE pg = 13 AND dbo_Resource.type_cs=rstype.cs_rid ORDER BY Date_Entered DESC" 'response.write fullsql set foundres = conn.execute(fullsql) %> Resource Search Results
NWREL header
NWREL NWREL Search Resources Hot Topics What's New Programs and Services Organization NWREL
NWREL Resource Library

<% if rc = 1 then %> Your search found 1 item:

<% else %>Latest 20 Additions to the National Mentoring Center's Resource Collection:

<% end if if not FoundRes.eof then CurrentRecord = 0 for currentrecord = 0 to 38 if curprogram <>foundRes("pg") then if curprogram <> "" then response.write "

" select case foundRes("pg") case 4 response.write "From the Comprehensive Center, Region X, Collection
" case 12 response.write "From the Math and Science Education Center's Collection
" case 13 response.write "Ordered from most recent
" 'case "PIRC" ' response.write "From the Parent Information Resource Center's Collection
" case 14 response.write "From the National Safe Schools Center's Collection
" case "ARTICLES" response.write "From the Article Collection
" case else response.write "From the " & foundres("program") & "
" end select curprogram=foundRes("pg") end if response.write "" FoundRes.MoveNext CurrentRecord = CurrentRecord + 1 next response.write "
" & FoundRes("title") & "
" & foundres("author") response.write "
" & FoundRes("call_number") & "
" & foundres("ResourceType") response.write "
  Added
" & formatdatetime(foundres("date_entered"), 2) & "
" else %>

There were no records which matched your search criteria. Try a search with broader criteria. <% End If FoundRes.Close Conn.Close %>
New Search



| Home | Search | Resource Directory | Hot Topics |
| Programs and Services | What's New | Organization |
| Return to Top |

NWREL Northwest Regional Educational Laboratory
101 SW Main, Ste.500, Portland, OR 97204
Telephone (503) 275-9500
Resources: Resource Collection Search Results
Last Update: 5/20/1999 - Contact Webmaster