[thelist] ASP: More Selective Select

Damien COLA damiencola at wanadoo.fr
Thu Jul 3 05:35:59 CDT 2003

I guess there can't be no productive debate on this ;-)
For me, the best proof that singular should rule tables world is that in
Merise method we're talking about an entity, not a set of things. You
have an entity, like THE employee, that you describe, in relation with
other entities.

It's only when you're using your database that you can talk about set of
objects, objects are rows.

But I understand the opposite view and in a parrallel dimension I am
supporting it. But in this dimension I am unoriginally supporting the
majority view.. ;-)

I agree with the second advice, which is also not to have too long
fields or table names, it's because I am still not using a RDS and have
to enter manually all SQL queries, deal with the results in PHP, etc.. 

Have a nice day,

  Damien COLA

-----Original Message-----

the concept is of sets of things

the set of employees, the set of jobs...

thus,   select ... from employees

casey, a more important rule than using plural names for tables is NOT
to embed the "type of the thing" into the name of the thing

for example, do not say  tblEmployees  or  colFirstname

adjective_that noun_practice verb_is adverb_really



* * Please support the community that supports you.  * *

Evolt.org conference in London, July 25-27 2003.  Register today at

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list