I had a similar problem and I solved it by writing a stored procedure that
returned the results already grouped, so I only had to use a standard
<cfoutput> (without the group= attribute). It ended up being a pretty long
and complicated query, but it was the best way that I could think of doing
it.
If you'd like I can look at your query and result page and see if I can
suggest anything,
Bob
-----Original Message-----
From: Patric Stumpe [mailto:[EMAIL PROTECTED]]
Sent: March 20, 2001 9:26 AM
To: CF-Talk
Subject: Advanced Previous/Next-Records Navigation
Hi fellows,
i have the following problem. On one of my sites I have result-pages
for querys where a lot of records may be outputted. Now I want to
include a Previos/Next-Navigation with 25 records displayed per page.
The problem is that the query is grouped by two columns before the
actual record is displayed. So i don't have the ability to work with
the standard approach with limiting the output via <cfoutput
query="foo" startrow="#start#" maxrows="25"> because only the outer
two grouped cfoutputs use the query-attribute.
I hope someone does understand what I mean and can help me.
Below is the adress of the mentioned site called Teilemax.de. There
you can enter a space in the formfield "Schnellsuche" (quicksearch)
and you get the result-page.
For the coders out there I would also send my code off-list 'cause I
think it would blow this mail.
--
thanx in advance
Patric Stumpe
Knust & Stumpe Datentechnik
Abt. Webdesign
mail: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
