'80040e10' No value given for one or more required parameters. (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

dangmoss -> '80040e10' No value given for one or more required parameters. (9/13/2006 5:30:24)

search11 = request.form("search1")
myDSN="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("/_private/order.mdb")
mySQL = "SELECT * FROM Orders WHERE (TitleSubmitter LIKE " &search11&")"
response.write mySQL

this yields



SELECT * FROM Orders WHERE (TitleSubmitter LIKE dangmoss)
Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/searesults.asp, line 53


What am I doing wrong?




rdouglass -> RE: '80040e10' No value given for one or more required parameters. (9/13/2006 10:24:32)

quote:

mySQL = "SELECT * FROM Orders WHERE (TitleSubmitter LIKE " &search11&")"


You're missing apostrophes and percent signs to use when searching text fields (percent is with LIKE). Should look like this:

mySQL = "SELECT * FROM Orders WHERE (TitleSubmitter LIKE '%" &search11&"%')"

That help?



dangmoss -> RE: '80040e10' No value given for one or more required parameters. (9/13/2006 20:21:34)

Yes good grief! It's a constant battle to figure out the syntax.

You and spooky have helped me so much I need to send something.... to yall.




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125