one thing I can suggest is make use of the maxrecords option in the
<cfquery> tag.
and then in the query say portfolio.TypeID> then page number etc etc.
I hope U understand.
just in case U have sorting stuff also then this kinda thing gets a bit
complicated.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
-- Phoenix Global Solutions (India) Pvt Ltd., www.pgsolutions.com
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
"Michael
Wilson" To: CF-Talk <[EMAIL PROTECTED]>
<mwilson@xion cc:
media.com> Subject: Next and previous records
08/20/01
10:53 AM
Please
respond to
cf-talk
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
