By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,137 Members | 2,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,137 IT Pros & Developers. It's quick & easy.

asp search returns no results from access query

P: n/a
access 2000 query:

here's what i want to do. from an asp page, perform a search on a
table in access. i have used sql code in the asp page itself, but i'd
rather execute a query in access. i have success in running any query
(basic SELECT, SELECT with conditions _other_ than LIKE, etc..) for
some reason, when i execute the query below from the asp page, i get
no results.

the search.asp page just has a text box in a form that submits the
srchBOX field to the results.asp page.

here's the asp code from the results.asp page:

Dim vSearchParam
vSearchParam = Request.QueryString("srchBOX")
Set rsTODO = conn.Execute ("exec sp_SEARCH_TODO" & " '" & vSearchParam
& "'")

even if i replace vSearchParam with an actual string such as "asdf"
(and this does return results from the access query), i get no results
in my results.asp page.

what gives? i must be missing something simple here... i'm not sure if
it's an access or asp issue..

please help!

thanks

"sp_SEARCH_TODO"

SELECT mnu_REQUESTTYPE.requestTypeNm, mnu_STAFF.staffNmFirst & " " &
mnu_STAFF.staffNmLast AS whoRequested, tbl_TODO.todoID,
tbl_TODO.todoStampDate, tbl_TODO.todoStampTime, tbl_TODO.todoNm,
tbl_TODO.todoDsc, tbl_TODO.todoPromiseDate, tbl_TODO.todoPromiseTime,
tbl_TODO.todoDeliverDate, tbl_TODO.todoDeliverTime,
tbl_TODO.todoNotesFollowUp, tbl_TODO.todoTimeToComplete,
mnu_STAFF_1.staffNmFirst & " " & mnu_STAFF_1.staffNmLast AS
whoDelivered, mnu_STAFF_2.staffNmFirst & " " & mnu_STAFF_2.staffNmLast
AS whoPromised
FROM ((mnu_REQUESTTYPE RIGHT JOIN (mnu_STAFF RIGHT JOIN tbl_TODO ON
mnu_STAFF.staffID = tbl_TODO.staffNmFirst) ON
mnu_REQUESTTYPE.requestTypeID = tbl_TODO.requestTypeNm) LEFT JOIN
mnu_STAFF AS mnu_STAFF_1 ON tbl_TODO.whoDelivered =
mnu_STAFF_1.staffID) LEFT JOIN mnu_STAFF AS mnu_STAFF_2 ON
tbl_TODO.whoPromised = mnu_STAFF_2.staffID
WHERE (((tbl_TODO.todoDsc) Like '*' & [vSearchParam] & '*'));
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.