Database search
Locate a translator From: <% Set oRs = oConn.Execute("SELECT Language, LanguageID From Languages WHERE Searchable = true ORDER BY Language") Do while (Not oRs.eof) %> " <%if oRs("Language")="English" then Response.Write("SELECTED")%>><% = oRs("Language")%> <% oRs.MoveNext Loop %> Into: <% oRs.moveFirst Do while (Not oRs.eof) %> " <%if oRs("Language")="English" then Response.Write("SELECTED")%>><% = oRs("Language")%> <% oRs.MoveNext Loop oRs.close %> Subject Area: Any <% Set oRs = oConn.Execute("SELECT SubjectArea, SubjectAreaID From TranslatorSubjectAreas ORDER BY SubjectArea") Do while (Not oRs.eof) %> "><% = oRs("SubjectArea")%> <% oRs.MoveNext Loop oRs.Close %> Native Language: Any <% Set oRs = oConn.Execute("SELECT LanguageID, Language From Languages ORDER BY Language") Do while (Not oRs.eof) %> "><% = oRs("Language")%> <% oRs.MoveNext Loop oRs.Close %> State: Any <% Set oRs = oConn.Execute("SELECT DISTINCT State From Members ORDER BY State") Do while (Not oRs.eof) %> "><% = oRs("State")%> <% oRs.MoveNext Loop oRs.Close %> City: Any <% Set oRs = oConn.Execute("SELECT DISTINCT City, State From Members ORDER BY State, City") Do while (Not oRs.eof) %> <%=oRs("State")%>, <%=oRs("City")%> <% oRs.MoveNext Loop oRs.Close %> Include Individuals Include Agencies <% oConn.Close set oConn = nothing %> Basic Search
©1997-2008 AATIA. All rights reserved.
