none
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?

     

    Rui

    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.

     

    RUi

    Thursday, August 23, 2007 2:50 PM