| |
| |
| |
|
Comments:
<0> scirre good morning
<0> thanks for your help yesterday about isa
<0> it is less slow now
<1> awsome! no problem
<0> do you have some more habbit on the hat ? hehe
<1> habbit on the hat? what does that mean? =)
<0> hehe
<0> do you have some other magic , to isa 2004 hehe
<0> to teach me
<1> hehe not today, got work todo sorry :)
<0> ok
<0> thanks
<2> I have this design question.. I have this field in this table, it stores membership in some organizations, I list 4 organizations, and they could be member of 0 or 1 or more than 1 of those organizations
<2> how do I store multiple org values in this single field
<3> tbl_memberships with fields fld_personid | fld_organizationid
<3> fld_personid relating to the person in a persons table
<3> fld_organizationid relating to the organization in an organizations table
<2> I want to avoid creating another intermediate table
<3> thats the way the rest of the world does it, for the good reason that there is no better alternative
<2> I don't have an organization table
<3> make one
<2> and it's not a mandatory field either
<2> can I just put the org codes seperated by commas?
<3> you could, but it would be ugly searching
<3> is it only the 5 possible states?
<4> use integer
<4> I use this way for security signatures for accounts
<4> like this :
<4> "00000000000000000000" , that's 20
<4> "10000010011101010100" , that's 20 with some of them active
<4> section 1 is "can see prices"
<4> section 2 is "can order"
<4> etc etc
<4> not sure if that is what u meant
<4> anyway, that way I only have one field
<3> bit masking
<4> but if u need to connect to multiple stuff
<4> that's not a good way
<4> you should have a link table inbetween
<4> and ofcourse, the mother****er dies
<4> that's why I never help random people
<4> hehe
<0> NIGHT
<0> scirre
Return to
#sql
or
Go to some related
logs:
www.hayategitim.com
Trublz
Madagascar-I like to move it.mp3
mail bomba
Soldiercayne
#india
#kl
red bull low sperm
#photoshop
#india
|
|