|
|
|
Hawk
Local Access Numbers Search
Please make sure:
1. Type valid area code (not zip code) when searching by area code.
2. Type 2 letters for state (i.e. Georgia will be GA not Georgia).
When searching by state.
<%If in_Txt<>"" and by_select<>"" Then
Select Case(by_select)
Case(2)
Finder = "State"
Case(3)
Finder = "City"
Case(1)
Finder = "areaCode"
End Select
rsQuery.Open "select * From numbers WHERE "&Finder&" Like '%"&in_Txt&"%'", dcnDB
%>
| State |
City |
Access
Number |
<%Do While Not rsQuery.EOF%>
| <%=rsQuery("State")%> |
<%=rsQuery("City")%> |
<%=rsQuery("Phone")%> |
<%rsQuery.MoveNext
Loop
rsQuery.Close
End If%>
|
 |