Master Detail Madness!

[corychauvin]

Hello,

i'm setting up a simple photo gallery, where the thumbnails are on one page and the large version of each on a detail page. I want to use the "move next" "move Prev" on the detail page so the user doesn't have to go back the master thumbnail page. My problem is that i have a filter on the detail page to grab the proper thumbnail photo the user might have clicked on. Well this only retrieves one row from the DB, if i remove the filter the "move next" "move Prev" works fine only it defaults to the first image and not the image the user clicked on?

How do you set this up so that the detial page will grab the proper photo the user clicked on and have the recordset get all the rows so you can use the 'move next' "move prev' and as well have them navigate from the proper position.

 

[johnwm]

You can write your SQL statement to include an index value. If you use ASP, the Getrows function will store the recordset in an array. Use a session variable to store the array, and set the next and previous pointers using the array values. You will also need a session variable to store the recordset count to allow your previous and next to roll-over

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints