MX Looper Forum :: query group by with MX Looper
This thread was displayed: 238 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
Sandra Sailer
10-30-2006 15:56:57 GMT +2
|
I want to create a query output using the group property, so the query looks something like this:
<cfoutput query="getlocs2" group="status" startrow="#StartRow#" maxrows="#MaxRows#">
#getlocs2.CompanyName#<br />
</cfoutput>
I cannot get MX Looper to work using a "group=" property. How can this be achieved with MX
|
|
|
Ionut MOICIANU
10-31-2006 17:58:24 GMT +2
|
Hi,
Indeed, this does not seem to work. You should a Recordset query filtered with GROUP BY instead.
Ionut
|
|
|
Sandra Sailer
10-31-2006 20:47:53 GMT +2
|
Well, I already have a recordset with a group by property, but want to still be able to page through it by using page numbers. Is this a potential future enhancement of the MX Looper tag that Interakt would consider?
|
|
|
Ionut MOICIANU
11-01-2006 11:47:48 GMT +2
|
You can use the MX Navigation Pack extension to build the navigation.
Ionut
|
|
|
Ionut MOICIANU
11-01-2006 11:49:15 GMT +2
|
Sorry, I see you don't have this extension.. I am afraid the MX Lopper extension does not support your approach yet. I will note this request down.
Ionut
|
|
|
Sandra Sailer
11-01-2006 16:20:12 GMT +2
|
Where can I get the MX Navigation Pack that you recommend? I see it has been discontinued.
|
|
|
Ionut MOICIANU
11-02-2006 13:30:12 GMT +2
|
It's been discontinued, unfortunately. I wrongly presumed you already own it, sorry.
Ionut
|
|
|
Sandra Sailer
11-02-2006 16:22:37 GMT +2
|
Is the Navigation Pack a product that you would consider bringing back? It sounds like it's too useful to be discontinued...
|
|
|
