Solved

hey how can i pass the calues for search page

Posted on 2008-10-10
4
227 Views
Last Modified: 2013-12-08
hi,
i have 6 to 7 values that must pass from one page to query page to find out the exact search but how to do that please suggest
0
Comment
Question by:devilsuraj
4 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 22686014
you have several options:
* session data
* url parameters
* post data
* database contents

the easiest is the url, but it shows the user how to call the page, actually.
post data is similar to the url, also very easy, but can also be "spoofed"
the most secure is session data, and you save the parameter in the session, and then call (redirect) to the search page, which then uses the session data
saving the parameters in a database table, along with the session id, and then in the search page query for the search parameters first, or letting the query use the parameter values stored, is the "heaviest", but has some other advantages...
0
 
LVL 10

Assisted Solution

by:slamhound
slamhound earned 125 total points
ID: 22700324
Angel is right....I would use session variables.

On one page you would put something like:
session("MyFirstValue") = 12345

And then on every other page you can reference the session variable like any regular variable.
Str = "Select * from tblTable where Field = " & Session("MyFirstValue")
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
get multiple images to align right 5 45
WIX Redirect 1 38
Wrapper for APPs 9 40
ASP.NET MVC 2 6
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now