Script ASP - Database: Database Search - Morpheusweb.it - Webmaster resources: programming, asp script, using asp, file asp, asp, asp post, database asp, asp login, vb asp, asp access, asp download, asp script, formmail, area riservata, paginazione, scripts asp, mailform, asp script download

ABOUT >
WORKS >
CONTACT ME >
>

Home Page
> Script ASP
> Script ASP Database
> Database Search

Database Search

It makes a query on a string of keywords.
Splits the search string and for each value add a where clause to the query.



					
					<%

					SQL = "SELECT * FROM [myTABLE] WHERE ( "

					searchArray = Split(Trim(Request("searchPhrase")), " ")

					for i = 0 to ubound(searchArray)

					  SQL = SQL & " title LIKE '%" & searchArray(i) & "%' OR "

					next

					SQL = Mid(SQL, 1, Len(SQL)-3) & " )"

					%>