Webmaster Forum / ColdFusion / Advanced Techniques / September 2007

Hi
I am trying to create a master detail page for a photography site, easy enough
but I am trying to put next and previous links on the detail page next to the
image so that you can go to the next and previous record from the original
query on the detail page.

I have tried everything but can't get it working, I read a few forums and they
said it couldn't be done so here's a challenge if anyone would like to accept
it.

I somehow need to get the original recordset from the master page across to
the detail page and what position the photo had in the recordset.

Please help
Kris

Here is some crude code

<!--- master page --->

<cfquery name="master" datasource="#Application.dsn#">
SELECT *
FROM Photos
ORDER BY PhotoRating ASC
</cfquery>

<cfoutput query="master">
<a href="detail.cfm?PhotoDatabaseID=#master.PhotoDatabaseID#">
<img src="#Application.PathToPhotos##master.Image#" width="100" />
</a>
</cfoutput>

<!--- detail page --->

<cfquery name="detail" datasource="#Application.dsn#">
SELECT *
FROM Photos
WHERE PhotoDatabaseID = <cfqueryparam value="#URL.PhotoDatabaseID#"
cfsqltype="cf_sql_numeric">
</cfquery>

<img src="#Application.PathToPhotos##detail.Image#" width="800" />
<a href="detail.cfm?PhotoDatabaseID=#????????#">next</a> | <a
href="detail.cfm?PhotoDatabaseID=#??????#">previous</a>  |  <a
href="master.cfm">back</a>