|
| |
'80040e10' No value given for one or more required parameters.
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
dangmoss
Posts: 12
Joined: 8/23/2006
Status: offline
 |
'80040e10' No value given for one or more required par... - 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
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: '80040e10' No value given for one or more required... - 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?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dangmoss
Posts: 12
Joined: 8/23/2006
Status: offline
|
RE: '80040e10' No value given for one or more required... - 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.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
