« Return to Thread: VWP - dropDown bound to DB question

Re: VWP - dropDown bound to DB question

by yossarian :: Rate this Message:

Paul Belleville wrote:

What if I have a dropDown bound to a DB table so it provides the choices.
However, I also want to add an empty selection since null is a valid choice for this field in which this data will eventually be saved.
I guess I can add a null to the selection DB table.. is there a better way?

Paul

Another approach is to use a UNION in the SQL statement eg:

select null,'' union
select aircraftid, shortreg from aircraft

« Return to Thread: VWP - dropDown bound to DB question