Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Ultra Media Gallery 5.3
Ultra Media Gallery is the most popular photo gallery and media gallery module for DotNetNuke, the major purpose of this module is to allow you create unlimited pictures and medias to your gallery and organize them by albums, your albums and medias are browsed in flash interface.

Flex By DrNuke
The Flex skins are professionally designed, coded and packaged by a team of DotNetNuke experts. Available in 8 great colours, each with 15 banner images, 2 menu types and a choice of 3 background styles. The entire pack features a total of 2448 skins!

Ultra Video Gallery 2.3
Ultra Video Gallery is a brother product of Ultra Media Gallery, The major purpose of this product is to provide an easy way to add videos in various formats to your website by and play them in a unique flash gallery.

Open-DocumentLibrary v3.0
Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Engage: Publish 5.1
Content Workflow + Versioning + Categorization + Multiple Display Options = Truly Advanced DotNetNuke Content Management (Requires DNN 4.5.1 or later)

XMod 5.1
Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

Events Calendar and Registration 2.1.8 for DNN4.xx
One stop solution for events calendar and events registration! Demo site available for free trial.

Form Master 1.6 For DNN 4
Form Master 1.6 improves on the success of version 1.5 with new features in Function, and Presentation, while maintaining the Intuitive User Interface. Form Master 1.6 delivers visual form design where input fields can easily be created, modified, and moved.

DNNMasters SEO Suite Enterprise w/Source
If you want better Search Engine ranking you need KeepAlive, URL Rewrite, Custom 404 error, Custom Redirect, Friendly URL's, Sitemap, Google Sitemap.DNNMasters SEO Suite delivers all of it and more!

CATALooK.netStore Pro & Booking Tools w/source DNN4
Powerful multilingual, search engine optimized ecommerce store and renting/letting system including a concept utilizing many business models in one application integrates:Catalog,Media gallery,Configurator,Packages,Data entry forms,Subscriptions,Recurring billing,40+ CC Gateways,UPS and USPS support
    |   Register   |   Saturday, August 30, 2008   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Subject: capitalize first letter of each word
Prev Next
You are not authorized to post a reply.

Author Messages
Paul
Posts:6
skipping stones
skipping stones
03/11/2008 6:22 AM  

does anyone know how to capitalize the first letter of each word in a field I have tried sql and even css but can not seem to get it to work

 

Thanks

Paul
Chad
Posts:1863
river guide
river guide
03/12/2008 1:50 PM  
Paul,

Well I would first test this within your query analyzer or another application but you should be able to use the Substring and Upper functions of T-SQL to do this.


SELECT UPPER(SUBSTRING('paul', 1, 1))
+ LOWER(SUBSTRING('paul', 2, LEN('paul')))


Which returns Paul instead of paul. The first part gets the first letter and makes it a Capital. Then it concatenates the 2nd part but only starts with 2nd letter and forces them to be lower case.

Seems more complicated than it should though doesn't it?



-Chad
Paul
Posts:6
skipping stones
skipping stones
03/17/2008 2:41 AM  

How would I implement that.

 

Thanks

Paul
Chad
Posts:1863
river guide
river guide
03/17/2008 9:27 AM  
Ummm.... Well probably a SQL Event. You would need to know which field you wanted to update (lets say DisplayName) and then update the database directly. Something like:

Update Users
Set DisplayName = SELECT UPPER(SUBSTRING('$(FirstName)', 1, 1))
+ LOWER(SUBSTRING('$(FirstName), 2, LEN('$(FirstName)')))
Where UserID = $(UserID)


Another option might be to use a client side javascript function with the client side events. This would then change this from SQL event to basically a client side function that would automaticlaly capitalize the first letter. I would have to research more what this would be but it should be possible and not too difficult. This way when the user tabs off the field and they type paul or PAUL it would automatically make it Paul for them?


-Chad
Paul
Posts:6
skipping stones
skipping stones
03/18/2008 2:53 AM  

I understand this is not as simple as it looks but where would i add client side script as I have found some javascript that i know works but the question is where do i add it for the dynamic registration to use it.

 

Thanks

Paul
Chad
Posts:1863
river guide
river guide
03/18/2008 9:20 AM  

Paul,



Sorry my bad... The 3.2 release of Dynamic Registration will support client side events, I was thinking this was for Dynamic Forms and got confused. If you want to 'test' your solution before its release you can test Dynamic Forms on beta springs with the 'Client Side Javascript'. This specific area of development will be the same or similar between the two modules so if you get it working with Dynamic Forms it should be easy to move over to the 3.2 release (which is about 2-3 weeks out and currently in development).


To get a good idea for different types of client side events you can check out this demonstration for Dynamic Forms.



Chad
Paul
Posts:6
skipping stones
skipping stones
03/31/2008 11:22 PM  

How long till 3.2 is released and will in allow javascript to run for a field. As I have found some java script that will capitolize the first letter of each word in a field but there is no way to implement it into dynamic registration.

 

Thanks

Paul
Chad
Posts:1863
river guide
river guide
04/01/2008 1:24 PM  
Hi. Right now the release date is set for 4/30... Dynamic Forms 2.6 should be ready on or before 4/19 and Dynamic Registration 3.2 should be released on 4.30. We just posted the roadmap for the 2.6 release of Dynamic Forms and will release the Dynamic Registration roadmap of upcoming features shotly.

-Chad
Paul
Posts:6
skipping stones
skipping stones
05/19/2008 7:17 AM  

any news on release date yet as have not heard anything.

I know with something as complicated as dynamic registration it would be a while just woundering if you have an estimation date on the 3.2 release as it is past 4/30 and I have not seen any updates released. also is it still going to do client side script.

Thanks

Paul
Chad
Posts:1863
river guide
river guide
05/19/2008 4:07 PM  
Paul,

Hi. Yes this is running behind but not all that far behind... We are finishing up some development on the beta (right now all ready and coded except for PayPal integration and documentation). So... The goal this week is to have the finished beta ready by the end of the week and full release in early to mid June.

-Chad
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration > capitalize first letter of each word


ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement