formfields.com Forum Index formfields.com
FORMfields Forums
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Change display in CP to Captital letters for one field

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    formfields.com Forum Index -> FG 2.0 - Frequently Asked Questions (FAQs)
View previous topic :: View next topic  
Author Message
maria



Joined: 02 May 2006
Posts: 16
PostPosted: Sun Oct 15, 2006 4:38 pm    Post subject: Change display in CP to Captital letters for one field Reply with quote
Hello

Is it possible to change one field to display in capital letters even if the original data entered was not in capitals?

Thanks in advance

Maria
Back to top
View user's profile Send private message
formfields



Joined: 01 Aug 2005
Posts: 465
PostPosted: Thu Nov 02, 2006 5:01 pm    Post subject: Reply with quote
Yes, this can be done just by using a MySQL function. For example, in our A+ Doctors example, you can capitalize a doctor's name by changing:
Code:

define("FF_SELECT_CLAUSE", "doctor_name AS 'Doctor\'s Name', doctor_type AS 'Type of Doctor', insurance AS 'Types of Insurance Accepted'");

to
Code:

define("FF_SELECT_CLAUSE", "UPPER(doctor_name) AS 'Doctor\'s Name', doctor_type AS 'Type of Doctor', insurance AS 'Types of Insurance Accepted'");


For more MySQL functions please see the documentation at http://www.mysql.com
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    formfields.com Forum Index -> FG 2.0 - Frequently Asked Questions (FAQs) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group