Database Search
Locate an interpreter 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 %> 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("City")%>"><%=oRs("State")%>, <%=oRs("City")%> <% oRs.MoveNext Loop oRs.Close %> Specialization: Any <% Set oRs = oConn.Execute("SELECT ActivityDesc, ActivityID From InterpActivities ORDER BY ActivityDesc") Do while (Not oRs.eof) %> "><% = oRs("ActivityDesc")%> <% oRs.MoveNext Loop oRs.Close %> Mode: Any <% Set oRs = oConn.Execute("SELECT Mode, ModeId From InterpModes ORDER BY Mode") Do while (Not oRs.eof) %> "><% = oRs("Mode")%> <% oRs.MoveNext Loop oRs.Close oConn.Close %> Include Individuals Include Agencies
©1997-2008 AATIA. All rights reserved.
