codice:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("mdb-database/....mdb")
nulla = "http://www....."
recupera = replace(Request.Form("srch"), "'", "''")
if IsNull(recupera) then
response.redirect nulla
else
end if
(da qui in poi funziona)
codice:
sql = "SELECT * FROM artisti WHERE artista LIKE '%"&recupera&"%'"
set rs = conn.execute(sql)
if not rs.eof then
vaia = "http://www......asp?id="&rs("id")
response.redirect vaia
else
response.write "No matches found"
end if