Advice on method to read data from database

[RobColborne]

Hi

Just need some advice rather than solving a specific problem.

I have an ASP page that pulls data from a database into a table. In each row I have a hyperlink that I wish to 'Zoom' which I have workig in a pop-up window.

So far I have the link working with the window appearing correctly and am able to get the record ID for the selected record.

I am not sure on the best method to pass the record ID to the popup window to do another query, or is there a better way. I thought about opening another recordset in the main window and then passing the values to be displayed to the opened window, but not sure how I would achieve this. Or what the best method would be.

I hope I have explained myself correctly.

Thanks

Rob

 

[FesterSXS]

You could either of those methods really.

How much info are you extracting from the DB?

1) If it is lots then I would just pass the record ID to the popup window and requery the database.

window.open('myPage.asp?id=87','PreviewWindow','top=0, left=0, width=800, height=600');

2) If it is just a handful of small things being returned then you may as well append them to the QueryString when you open the popup window (especially if you are hiding the address bar on the popup).

window.open('myPage.asp?name=fred&age=45&cupsize=34DD,'PreviewWindow','top=0, left=0, width=800, height=600, toolbar=no, menubar=no, status=no');

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com

 

[RobColborne]

Cool, I'll opt for option one.

Thanks for your help, not being an ASP programmer sometimes it feels like stumbling around in the dark