Installation and deployment
Version 7.x > Installation and deployment > Extra 'Select' item in drop down list View modes: 
User avatar
Member
Member
positivepurchasing - 1/22/2014 3:43:24 AM
   
Extra 'Select' item in drop down list
Hi.

In Site Manager > Development > System Tables > User I've have added a custom field which uses a drop down list with a sql query, which works fine. However is there a way to add a 'Select' item at the top so that with the validation it forces the current user to select a value?

Cheers
Paul.

User avatar
Kentico MVP
Kentico MVP
Accepted solutionAccepted solution
Brenden Kehren - 1/22/2014 7:07:35 AM
   
RE:Extra 'Select' item in drop down list
I use UNION all the time, seems to work just fine.
SELECT '' AS Value, '-- select one --' AS Text
UNION
SELECT DISTINCT School AS Value, School AS Text
FROM custom_SchoolLookup
ORDER BY 2 -- ordering by display text, column 2

User avatar
Member
Member
positivepurchasing - 1/22/2014 7:50:47 AM
   
RE:Extra 'Select' item in drop down list
Nice one FroggEye, works perfect. Cheers mate.