Hi Everyone,

here's the situation.   We've got a bunch of fields that are enums,  that
can be null.  For example:

a user has a gender that is stored in a nullable column (it's a FK to a
Gender Table) and is represented in the application as an enum like so:

GenderEnum
NotSpecified
Male 1
Female 2

What we would like to do is have it put NULL in the database if it is Not
Specified.  and If it's NULL in the database have it set the field to
NotSpecified.

I tried making the enum nullable and setting notSpecified = nothing

but then when i try to use the enum  it doesn't work properly.

we are working with a pre-existing database and code base that we are
upgrading, and the less code that we have to mangle the better.

any suggestions on the best way to implement this scenario?

Thanks in Advanced

Patricia

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to