Joe I like your idea Ben mentioned Converting to Proper before Updating the DB SO:
> <cfloop list="#structKeyList(form)#" index="field"> > <cfset form[field] = CapFirst(Lcase(form[field]))/> > </cfloop> This works great. Using Lower case becuase CapFirst converts to upper but doesnt check for case in advance. This is going to be a global fix on several data entry forms. so I dont thing I care much about Mc Mac and Von in names at this point. the client didnt care about this bit, but addresses are a pet peeve of mine. thanks for all the help! Quote from this client "Wouldn't the data entry go faster if the business name, address, City, State, ZIp, and Phone were just in the same field?" "You can parse that out later right?" On 8/7/06, Joseph Lamoree <[EMAIL PROTECTED]> wrote: > > If you want to change the case of all the elements in the form > structure, you could loop of them like so: > > <cfloop list="#structKeyList(form)#" index="field"> > <cfset form[field] = ucase(form[field])/> > </cfloop> > > Or, you could loop over a subset of field names just to modify the > ones you want to change. > > -- > Joseph Lamoree > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
