Passing Multiple Parameters into Access Query

rit01 · October 26th, 2005, 10:40 AM

Hi All

I wonder if anyone can help. I have been using the Wrox ASP3 beginners book to create a search page looking up data within an Access 2000 database.

I have been trying to pass 2 parameters into a query but have had no success. I can pass one parameter with no problems. Can anyone show what I am doing wrong?

My code is:

Code:

strlname = request.Form("lname")
strSetCode = Request.Cookies("xyz")("Setcode")

Set objComm = Server.CreateObject("ADODB.Command")
objComm.ActiveConnection = strConnect
objComm.CommandText = "qryUsearch"
objComm.CommandType = adCmdStoredProc

Set objParam1 = objComm.CreateParameter("Required SetCodeP", adVarChar, adParamInput, 50)
objComm.Parameters.Append(objParam1)
objParam1.value = strSetCode

Set objParam2 = objComm.CreateParameter("Required lnameP", adVarChar, adParamInput, 50)
objComm.Parameters.Append(objParam2)
objParam2 = strlname

Set objRS = objComm.Execute

...Its probably simple but I am on a learning curve.

Many thanks in advance all!

Rich

rit01 · October 26th, 2005, 04:00 PM

Hi All

I found out what was causing the problem. It wasn't the code after all... What I was do is using the following wild card within my MS Access parameter:

Like "*" & [lnameP] & "*"

Now I can get the ASP to work without the wild card above but really to make a good free text search I need the wild card function

... does anyone know how to add a wild card type function to the Command.Parameter object?

Many thanks in advance

Rich