Get enum variables and saving to SQL Server RRS feed

  • Question

  • Hello guys.


    After solve some problems of a program.


    Now the problem is to save into a table.


    For example, I get the name, domain from a user. But there's a list of attributes which appers randomly ReadFile, Write, etc. But there's user that have 15 attriutes.


    What can I do to work with these params. Creating all the possible fields in the database?



    Wednesday, August 22, 2007 6:02 AM

All replies

  • You could move the 'attributes' out your user entity:

    user (user_id, name, ...)
    attributes (attribute_id, user_id, name, value)
    Wednesday, August 22, 2007 9:28 AM

    Thanks timvw


    I'll try do something with it.


    Thanks a lot.



    Thursday, August 23, 2007 2:50 PM