help! request.Form not helping on 2nd iteration
guys, i am working on this customer care code
here, after a login page, i am redirecting it to another page where the verification is happening & the username string is being passed to the new page where the data is being displayed using request. querystring as...........
eng2=request.querystring("enm")
rs.Open "select * from call where engineer_id='" & eng2 & "'",con
now i have put some checkboxes & dropdowns to refine the query.
eg.
<%if (request.form("DATE")<>"ON" and request.form("CS")="ON" and request.form("LOC")="ON") then
rs.open "select * from call where (call_status = '" & t3 & "') AND (level_of_call = '" & t4 & "') AND (engineer_id='" & eng2 &"')",con
end if
%>
here, the value of engineer is not being picked from the querystring & thus nothing is being displayed
i have tried putting eng2 in hidden field & tried to lift the value form there using request.form but even tht doesnt help
how do we pass a value from one page if request.form & request.querystring dont work???
please help me someone!!!
|