I have a page that displays a certain number of songs based on a songs-per-page setting. This could be 50, 100, 1000, etc. That part is all set up.
What I would like to do is have a link called "mark songs as listened" for that particular page of songs. My question is, how do I pass that particular listing of songs to the action page? I was thinking I could just pass the action page URL.displayrows and URL.startrow so that the query on the action page knows how many rows to pull and from what offset to start and perfom a INSERT SELECT. The only thing is that the original song listing query has a sort order (which obviously affects the display page) and that exact sort order would need to be duplicated in the INSERT SELECT otherwise I'm going to be adding the wrong songs to the join table. While this kind of code duplication obviously isn't preferred, this is a dopey little app that for which I don't really mind cut and pasting if I have to. What I'm really more interested in is if there's a better way of doing this. I also thought about setting a session variable, but that seems kinda clunky as well. It does ensure, though, that the correct records make it into the join table. Any other suggestions? Thanks! Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
