Forums (Obsolete)

Installation and deployment

Version 7.x > Installation and deployment > Extra 'Select' item in drop down list

View modes:


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.

Kentico Legend

Accepted 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


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

Top