DaniWeb Forum Index > Web Development > ASP

ASP Advanced Search

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2004

Posts: 234

Reputation: cancer10 is an unknown quantity at this point

Solved Threads: 0

cancer10

Offline

Posting Whiz in Training

ASP Advanced Search

Oct 17th, 2006

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

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
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
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

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<table>
  <tr align="center">
    <td><% response.Write rs(0) %></td>
    <td><% response.Write rs(1) %></td>
</tr>
</table>
<table>
  <tr align="center">
    <td><% response.Write rs(0) %></td>
    <td><% response.Write rs(1) %></td>
</tr>
</table>