on/off values

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 30550
interpreted = N
texte = I would like some advice about how I should built my database. I have a product db with 15 categories for each product that can be on or off.I am wondering if I should use 15 fields and store a true/false value in them or if it is better to have one text field in which I put the name of the categorie if it is true for this record.I want to be able to select records based on the value of the categorie (select all record belonging to category A B C G J K for example).Regards,laurent--- L a u r e n t P l a d y s L X I R_____________________________________________ +33 (0)1 44 68 80 60 (tel)_____________________________________________ w w w . l x i r . n e t  l t p l a d y s @ l x i r . n e t-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  Associated Messages, from the most recent to the oldest:

on/off values (Laurent Pladys 2000)

I would like some advice about how I should built my database. I have a product db with 15 categories for each product that can be on or off.I am wondering if I should use 15 fields and store a true/false value in them or if it is better to have one text field in which I put the name of the categorie if it is true for this record.I want to be able to select records based on the value of the categorie (select all record belonging to category A B C G J K for example).Regards,laurent--- L a u r e n t P l a d y s L X I R_____________________________________________ +33 (0)1 44 68 80 60 (tel)_____________________________________________ w w w . l x i r . n e t  l t p l a d y s @ l x i r . n e t-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  Laurent Pladys

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Secure server question (1997) Checking for blank form fields (sort of...) (1998) [WebDNA] WebDNA 6.2 and Mac OS X 10.5 Client / Server ? (2009) [] Boxes in Safari (2004) Strange Crash (1998) Summing fields (1997) More on IE5 (2000) Looking for PHP programmer (2007) Stats (2004) A question about security (1998) Mime Headers for Mail (1998) WCS Newbie question (1997) pull downs (1997) Re:2nd WebCatalog2 Feature Request (1996) OBDC Support (1997) What does this error mean? (2000) What am I missing (1997) [carts] and databases (1997) Summing fields (1997) Using [Showif] tag. Mac (1997)