471,081 Members | 918 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,081 software developers and data experts.

asp search returns no results from access query

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!



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
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
0 2685

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by leegold2 | last post: by
2 posts views Thread by Arsalan Ahmad | last post: by
4 posts views Thread by zakhirn | last post: by
14 posts views Thread by Simon Gare | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.