pass database values to popup window

[sharonc]

Using asp and Javascript (in Dreamweaver):
I have a window that displays all the data in a database record with a popup button to display the description field.
The window displays the data for record 7, when I click on on the popup button, the description field is displayed for record 1, the first record in the database, not the record 7, I'm currently on.

<td><strong><font size="5"><img src="../IMAGES/Description.gif" alt="Click Here" width="91" height="33" border="0" Onclick="MM_openBrWindow('

http://seims/projects/ApacheProject...rs=yes,resizable=yes,width=400,height=300')">

How do I get it to show the description for the record I'm viewing record 7?

 

[Kendel]

You need to pass the record id with it:

<td><strong><font size="5"><img src="../IMAGES/Description.gif" alt="Click Here" width="91" height="33" border="0" Onclick="MM_openBrWindow('[URL unfurl="true"]http://seims/projects/ApacheProjects/Description.asp?id="&recordID','Description','status=yes,scrollbars=yes,resizable=yes,width=400,height=300')">[/URL]

Then in the popup, you load the record description like this:

sql = "select description from myTable where id=" & Request.QueryString("id")

 

[sharonc]

Thank you for your quick response. Where do I tell it what the value is for &recordid?

 

[DreXor]

or you could assign it to a session variable if you're using them or a cookie,then just pull that when the window is opened and have less to pass via url, also helps in preventing caching of the pop up page just in case.

DreX
aKa - Robert