Michael, I realize you only just wrote a few minutes ago, and may still be working on a response to my earlier note.
As for your need for capitalizing the first words, I don't know if you wanted a SQL solution, but for a CFML solution, that's a great example of when to look at the good ol' cflib.org site, which has thousands of user-defined functions to do just the most flexible things. Searching there for "capitalize" found this as the first hit: http://www.cflib.org/udf/CapFirst Let us know if that (and the group code I offered, and the code to limit the inner loop) is helpful. /charlie From: [email protected] [mailto:[email protected]] On Behalf Of Michael Brown Sent: Tuesday, July 24, 2012 10:56 AM To: [email protected] Subject: Re: [ACFUG Discuss] Have a question about group limits Thanks Larry, I'm only querying about 4k records for this project, so the query is rather quick. But I will definitely snippet the code for future projects. BTW, would you have a string snippet for capitalizing the first letter of each work in a title output? ex. "the brown dog" - converted to "The Brown Dog". ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
