BIG THANKS CHARLIE! On Tue, Jul 24, 2012 at 11:04 AM, Charlie Arehart <[email protected]>wrote:
> 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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- -- Michael Brown 770-605-5240 Marketing Solutions with vision! http://www.singleconcepts.com
