save the pk values of songs currently displayed in a hidden field in the form - you can then use that list in an IN() clause in your query.... #valuelist(queryname.columnname)# is a quick way to create a list of values from a query...
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mike Soultanian wrote: > 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:319665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
