ok, Steve. Thanks. I have been put on something else right now, but will get back to your input. I am querying a telephone directory so that is why I mentioned DISTINCT sinceI have many of the same last names. Or was I wrong in thinking that and misinterpreting what DISTINCT really means?
-----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 1:13 PM To: CF-Talk Subject: Re: Custom Tag for Sorting Yeah sorry about that James.... So what's the problem you're having using the same bit of code with a CFLDAP query object? Is it that you've not got distinct rows in your CFLDAP result set? If that's the case then... <cfset variables.PreviousItem = ""> <cfset variables.RowCounter = 1> <cfoutput query="LDAPResultSet"> <cfif (variables.RowCounter GT ColumnCount) AND (variables.RowCounter mod ColumnCount is 1)> </tr><tr> </cfif> <cfif LDAPResultSet.Name IS NOT variables.PreviousItem> <td>#dn# #Name#</td> <cfset variables.PreviousItem = LDAPResultSet.Name> <cfset variables.rowcounter = variables.rowcounter +1> </cfif> </cfoutput> will keep a manual count of what row you're on and only increment that counter and display the item if its not a duplicate. The above assumes that your result set is ordered by LDAPResultSet.Name where Name is an item returned by your LDAP query. Hope that helps Regards Stephen ----- Original Message ----- From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 5:17 PM Subject: RE: Custom Tag for Sorting > i seem to have lost control of this subject, i just wanted to know how using > CFLDAP, to output my data: > > A E > B F > C G > D H > > INSTEAD OF: > > A B > C D > E F > G H > > > the response i got from Joseph Thompson should work > (http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=604), but i need > to adapt it to function with CFLDAP. > > > > > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 29, 2002 11:53 AM > To: CF-Talk > Subject: RE: Custom Tag for Sorting > > > > Well, that's the version - I was making sure people didn't > > think we were shipping a db server as part of the product. > > You realize, a year from now, you're going to be telling everyone how they > shouldn't be using PointBase Embedded, just like you are with Access now! > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
