Hi,
I am working on a project that requires "next example" and "previous
example" navigation for a portfolio section. On the initial portfolio page
the user is presented with a list of "project types" to choose from...
development, logo design, photography and etc.
Once the user makes a choice, I pop up a new window and proceed to output
the data for the first record. Right now I have MAXROWS set to 1 so I can
get the display's look down, otherwise I get every record. Eventually I
would like to allow them to move through the various examples (records) in
that category type in sequence using the same window and page.
I have looked at some of the next and previous record tutorials, but most of
them deal with presenting X number of records in groups... like next 5, last
5.
Given that my query looks for a URL.ID to determine what category to get the
records from; is there a way to give the user next and last options using
the same window and page.cfm?
the query in my pop-up cfm is:
<CFQUERY NAME="GetPortfolioContent" DATASOURCE="xionmediacom">
SELECT portfolio.*, media.*, clients.*, portfolio.Description AS PortDesc
FROM portfolio, media, clients
WHERE portfolio.TypeID = #URL.ID#
And portfolio.ID = media.PortfolioID
AND portfolio.ClientID = clients.ID
AND portfolio.ActiveStatus = 1
AND media.ActiveStatus = 1
ORDER BY clients.Client
</CFQUERY>
You can see what I am working on, since I probably did a crap job of
explaining myself, at:
http://ax.servehttp.com/clients/xion/portfolio.cfm
Any help is greatly appreciated,
Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
