Hello all,
I would like to learn the syntax for passing variables that I retreived from
a database to a second asp page. Currently, I'm using:
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a href=
""InterviewerIn fo2.asp?timeID= " & rs("Starttime" ) & " "">"
How do I add more variables to my link: <a href = ...?
ie Nameofcandidate and InterviewDate
in this context:
' Iterate through times
While Not(RS.EOF)
' If date changes
If lDateID<>RS("Da teID") Then
' If this is not first date, close out previous group
If lDateID>0 Then Response.write "</tr><tr><td
height=10><hr></td></tr>"
' Print header for new group
Response.write "<tr><td>Candid ate Name: </td><td>" & "<B>" &
RS("NameofCandi date") & "</b>" & "</td></tr>" & vbcrlf
Response.write "<tr><td>Interv iew Date: </td><td>" &
RS("InterviewDa te") & "</td></tr>" & vbcrlf
Response.write "<tr><td>Interv iew DateID: </td><td>" &
RS("DateID") & "</td></tr>" & vbcrlf
Response.write "<tr><td height=10></td></tr>" & vbcrlf
Response.write "<tr><td>Availa ble time
Slots: &nb sp;</td><td>Start Time</td><td>End Time</td></tr>" & vbcrlf
' Update group
lDateID = RS("DateID")
End If
' Print detail
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a
href= ""InterviewerIn fo2.asp?timeID= " & rs("Starttime" ) & " "">" & _
RS("StartTime" ) & "</a></td><td>" & RS("EndTime") & "</td></tr>"
& vbcrlf
Your help is appreciated,
Chieko 2 1915
InterviewerInfo 2.asp?timeID=1& Nameodcandidate =3&othervar=5
"Chieko Kuroda" <ck*****@med.un c.edu> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. .. Hello all, I would like to learn the syntax for passing variables that I retreived
from a database to a second asp page. Currently, I'm using:
Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a href= ""InterviewerIn fo2.asp?timeID= " & rs("Starttime" ) & " "">" How do I add more variables to my link: <a href = ...? ie Nameofcandidate and InterviewDate
in this context:
' Iterate through times While Not(RS.EOF)
' If date changes If lDateID<>RS("Da teID") Then
' If this is not first date, close out previous group If lDateID>0 Then Response.write "</tr><tr><td height=10><hr></td></tr>"
' Print header for new group Response.write "<tr><td>Candid ate Name: </td><td>" & "<B>" & RS("NameofCandi date") & "</b>" & "</td></tr>" & vbcrlf Response.write "<tr><td>Interv iew Date: </td><td>" & RS("InterviewDa te") & "</td></tr>" & vbcrlf Response.write "<tr><td>Interv iew DateID: </td><td>" & RS("DateID") & "</td></tr>" & vbcrlf Response.write "<tr><td height=10></td></tr>" & vbcrlf Response.write "<tr><td>Availa ble time Slots: &nb sp;</td><td>Start Time</td><td>End Time</td></tr>" & vbcrlf
' Update group lDateID = RS("DateID")
End If
' Print detail Response.Write "<tr><td> </td><td><Font size= ""-1""><B><a href= ""InterviewerIn fo2.asp?timeID= " & rs("Starttime" ) & " "">" & _ RS("StartTime" ) & "</a></td><td>" & RS("EndTime") &
"</td></tr>" & vbcrlf
Your help is appreciated, Chieko
Or you could use session variables:
Session("UserLa stName") = "Smith"
Response.Write Session("UserLa stName")
Best regards,
J. Paul Schmidt, Freelance ASP Web Developer http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jason Us |
last post by:
Does anyone have experience with passing variables from an ASP page to
a JSP page.
The way it currently works in passing the SSN in the URL. This cannot
be good.
I thought that storing a unique session ID in a cookie and referencing
the SSN from the Session ID would be the correct way to do this. But
since we have two separate servers, IIS and Websphere, how do we
coordinate the session ID?
|
by: Richard |
last post by:
**** Post for FREE via your newsreader at post.usenet.com ****
HI,
I am working on a project where I need to input data to a (local) HTML page
using multiple form elements, such as text, radio, checkbox, and dropdown.
When the form Submit button is clicked, I then need the input data either
written to another location on the same page, or written to another page (a
different frame would be fine)
|
by: Oscar |
last post by:
I am looking for a way to pass an ADO recordset that has been retrieved in
an ASP page to another HTML-page. Is there someone who can provide me with a
small sample or a link to see how this is done?
regards,
Oscar
|
by: opt_inf_env |
last post by:
Hello,
I know three ways to pass variables form one page to another. The first
one is to declare and set session variable. In this case if one goes to
another page (by clicking on hyperlink or pressing a button) value of a
session variable will be automatically seen on the new page. The second
way is to set hidden variables in the form and go to new page by
execution of this form (press a button or enter), and the last way,
which I...
|
by: Russell |
last post by:
Hi there,
I'm currently creating a .NET Web Application and I have a question about
passing values from one screen to another. I previously used Session
variables in the code to store these values, however I can no longer use
this method because of my current website "Cloaking" the URL. (When site is
cloked, the session variables don't seem to work with frames)
Anyway, I was wondering if anyone could offer an alternative, I have tried...
| |
by: Lee |
last post by:
Hi All
How can I pass options from one webpage into another webpage. When the user
clicks on the hyperlink I want them to be go to the next page but I need to
pass in a number that the next page needs to reference.
Thanks
Lee
|
by: Jim Heavey |
last post by:
I know that I can create session variables and pass those values from one
screen to another, but is there not a way to makes variables from one scree
n available to another screen other then session variables? Is there not a
way to create properties in the one screen and then pass some sort of
reference to the screen you are calling?
Can you point me to an example or an article on how to use?
Thanks in advance for your...
|
by: Eric |
last post by:
Hello,
I am trying to come up with the best way to pass large amounts of data from
page to page, namely a data table.
The user needs to enter data into a form in one page and confirm it on
another. Session variables seem like the easiest, but I'm afraid of
crashing the server after deploying with a few hundred users as opposed to
just a few developers/testers. Any ideas?
|
by: Khai |
last post by:
First off, yes, I understand the crapload of tutorials out there, (well,
rather, I understand there /are/ a crapload of tutorials out there), the
problem is my comprehension.
I'm trying to pass variables, and can do so just fine with a URL, and $_GET.
What I would like to learn, and be very adept at using is the Form functions
and how you pass through that.
The problem in my comprehending this, is how does the original page know how...
|
by: Kausar |
last post by:
Hello All,
How do i pass the value from a page that exists on some domain to
another page that exists in subdomain.
Regards
Kausar
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |