D
david liu
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] & '*'));
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] & '*'));