Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > ASP Forms
|
ASP Forms As of Oct 5, 2005, this forum is now locked. Please use "Classic ASP beginner" at http://p2p.wrox.com/forum.asp?FORUM_ID=54 or "Classic ASP Professional" http://p2p.wrox.com/forum.asp?FORUM_ID=56 instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP Forms section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 16th, 2004, 01:00 AM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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!!!
 
Old March 16th, 2004, 12:30 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

I don't quite understand what is going on here? Are we talking about 1 or 2 page hits? You have the login page, this redirects to the query page. Then you have some dropdowns to refine the query and then you re-post the form? Is that what is happening?

Putting the value from eng2 into a hidden element with the same name as the querystring argument should do the trick, but you say that doesn't work.

A possible better solution, particularly because you have login functionality is to use the Session. Once the engineer logs in, save the engineerID in the session and use that in the other pages and you won't have to worry about carrying that value around with you on the querystring or in hidden form fields.

Peter
------------------------------------------------------
Work smarter, not harder.
 
Old March 18th, 2004, 02:08 AM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks a ton
the session idea worked fine!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Request.Form / Request.QueryString Toran Classic ASP Databases 4 January 17th, 2007 02:23 PM
Why no one is helping?????? This is my 3rd request SMI Word VBA 1 September 29th, 2006 03:59 AM
helping starters pokiri SQL Server 2000 1 August 31st, 2006 05:03 AM
request.qurystring vs. request.form Durwood Edwards Classic ASP Databases 3 June 18th, 2004 12:09 AM
request.querystring() , request.form() alyeng2000 ASP.NET 1.0 and 1.1 Basics 1 December 30th, 2003 12:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.