2. ASPRunnerPro General questions
  3. SET UPPER CASE
This topic is locked

SET UPPER CASE

 		4/25/2005 13:48:45
ASPRunnerPro General questions
S
 Skynet author

Hi:
Is possible set upper case for all fields. I try to prevent that users input information in lower case in database.
Thanks for your help.
Sergey Kornilov admin 4/26/2005

Hi,
you can use Template Editor for this purpose. Run it and create a new Template.
Modify edit.asp file (see my changes in bold):

if GetEditFormat("##FIELD##")<>FORMAT_DATABASE_IMAGE and GetEditFormat("##FIELD##")<>FORMAT_DATABASE_FILE then

  rs("##FIELD##") = UCase(strValue)

else


Repeat the same with add.asp file.
Use this template in ASPRunnerPro.
E
 		ebolisa 5/13/2008

Hi,

How would the post be applicable in 5.2?

The add and edit pages have changed since then.

Thank you.

Emilio
Sergey Kornilov admin 5/13/2008

In ASPRunnerPro 5.2 you can use BeforeAdd/BeforeEdit events and the following code:

dict("FieldName") = UCase(dict("FieldName"))