searching a whole database

hi, i would liek to know if it is possible to search a hole database in asp, every table basically, thanks in advance

-baleric

.... anyone? :cool:

I don't think you can search for the whole database but you can always search for each table and save the results with arrays.


Dim x, i
i = 0
For x = 1 to NumOfTablesInDatbase
SQL = "SELECT * FROM table" & x & " WHERE (condition)"
While not rs.eof
ArrayName(i) = rs("name")
ArrayId(i) = rs("id")
Array("type") = rs("type")
'etc etc
i = i + 1
rs.movenext
Wend
Next

im not that pro of a coder lol.. :( thanks anyways

You can also get a list of tables in the DB by using the system tables.

And of course if the fields are structured the same you could put a bunch of SQL statements together with UNION.

http://www.w3schools.com/sql/sql_union.asp

And for a related link (although it only uses one table):

Classic ASP Design Tips - Search For Keywords on Multiple Fields
http://www.bullschmidt.com/devtip-searchmultiplefields.asp