> > TABLE Loop_allname > > TABLE Loop_country > > TABLE (look up) Loop_country_list > > TABLE Loop_BirthY > > TABLE Loop_BirthM > > TABLE Loop_BirthD > > TABLE Loop_birth_D > > TABLE Loop_birth_M > > TABLE Loop_birth_Y > > TABLE Loop_email_to_name > > TABLE Loop_email_address > > TABLE Loop_review_by > > TABLE Loop_review > > TABLE Loop_GuBk_by > > TABLE Loop_GuBk > > what is the significance of the stem "Loop_"? > > and no, you do not need separate tables for year, > month, and day > > ;o) > rudy,
'Loop' is the site identifier; thinking ahead to having similar sites. My reason for thinking of three tables for the date is for ease of extracting the birthday, though I suppose in one table one can select the month and then sub select the day just as easily and less messily. In fact I probably don't need the look up tables either; is it easy to identify a date in the date type i.e. to select all the rows for a particular day of the year? Pat, The date stamp might be a very good idea for the reviews and guest book; For the rest the data is in use or it is not, though if there is a time delay requirement, as Matt suggested, it will be needed. Thanks. Joseph ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
