Solved

passing variables between webpages

Posted on 1998-12-17
9
200 Views
Last Modified: 2013-12-16
I use FP98 to create the webpage, VB5 to write the cgi scripts and Access 97 to keep the data.  I have a webpage which displays the result after querying the database.  The result will have a hyperlink to another webpage.  So, how do I pass the result (data from database) to the final webpage?  Is it possible to use simple html to do this?  

Thanks in advance...
0
Comment
Question by:gen101298
9 Comments
 
LVL 2

Expert Comment

by:jedimike
ID: 1840724
you cant use html to do this. you have to use cgi or asp and you can do it two ways....
you can do hidden fields that get submitted through a form or passed through get in the query string...(...cgi?variable=blah+..)

you can start this by doing javascript and "myform.submit" after triggering an event

0
 

Author Comment

by:gen101298
ID: 1840725
Can u give me a more detailed example?  I don't quite understand with the one that u gave...thanks
0
 

Author Comment

by:gen101298
ID: 1840726
I do like this,
<a href="http://default/sample.htm?Data1=" & rs.Fields("Data1") & "&Data2=" &             rs.Fields("Data2") & "&Data3=" & rs.Fields("Data3")  target="blank">

But the final webpage can only get the value of Data1, it can't get the others.  If my Data1 has the value of "My data", the final webpage gets only 'My', but no 'data'.  Please help...
0
 

Author Comment

by:gen101298
ID: 1840727
I need more detailed answer, please...
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 10

Expert Comment

by:MasseyM
ID: 1840728
You will need to use a server-side script language such as ASP (Active Server Pages) which looks like you are doing.  If you will email me the database and you ASP pages, I will take a look for you.  masseym@javanet.com

Thanks,

matt
0
 
LVL 4

Expert Comment

by:ruperts
ID: 1840729
Another Solution is to create a cookie on the users machine, then when the next page loads the page can read this data from the cookie, and then delete the cookie!


0
 

Author Comment

by:gen101298
ID: 1840730
To MasseyM,
actually I've tried using asp to pass variables and it works beautifully, but I must use VB to write the cgi for this project I'm doing...anyway, thanks!
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1840731
You can always use layers and the <DIV> commands... just hide the information until you need it again... I amnot and expert in this, but I know many here that are.

0
 

Accepted Solution

by:
indranil earned 100 total points
ID: 1840732
your problem lies in the spaces that are present in the query string, like "xyz.html?a=My Data&b=Your Data" will only pass
"a=My". what you need to pass is "xyz.html?a=My+Data&b=Your+Data"
which will keep the entire string intact. use javascript to replace space by '+' and it will work.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SVG Star 4 33
Synchronizing CSS load 3 29
Centering Vertically 3 26
Bad <form> statement? 9 20
This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
This article describes how to create custom column layout styles for Bootstrap. The article uses 5 columns to illustrate the concept, but the principle can be extended to any number of columns.
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

943 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

6 Experts available now in Live!

Get 1:1 Help Now