Søge i flere tabeller i database !
Hvorfor virker dette her ikke, ( Det skal bruges til en søgemaskine ):Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../system.mdb")
strSQL = "SELECT * FROM login WHERE"
strSQL = strSQL & " (Brugernavn LIKE '%" & request.form("brugernavn") & "%')"
strSQL = strSQL & " OR (Navn LIKE '%" & request.form("navn") & "%')"
strSQL = strSQL & " OR (Alder LIKE '%" & request.form("alder") & "%')"
strSQL = strSQL & " OR (Fra LIKE '%" & request.form("fra") & "%')"
strSQL = strSQL & " OR (Tlf LIKE '%" & request.form("tlf") & "%')"
strSQL = strSQL & " OR (E-mail LIKE '%" & request.form("email") & "%')"
Set rs = myConn.Execute(strSQL)
Jeg for fejlmeddelelsen:
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/eks projekt/enter/profil/find.asp, linje 122
