ASP Advanced Search

[cancer10]

Well I am trying to search a database using ASP. I want to search all the names of persons in a database by their mobile number.

The mobile numbers are entered in a textarea and needs to seach them at once.

I could not figure out how can this be solved.

I am using the following code

str= request.Form("txtbulk")
splitarray = split(str,chr(13))
for i = 0 to ubound(splitarray)
'response.write splitarray(i) & "<BR>"
rs.open "select * from tblcontest where mobile='" & splitarray(i) & "'",conn,1,3
next

and display the result here

<table>
  <tr align="center">
    <td><% response.Write rs(0) %></td>
    <td><% response.Write rs(1) %></td>
</tr>
</table>

i am not sure if this is the correct way to code this, may be someone can help me?