Re: Adding repeating events to a database

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39572
interpreted = N
texte = >Hello, > >I am creating a calendar system and want users to be able to enter repeating >events. These events will most likely be something like 3rd Saturday of the >month and so forth. > >I think I have part of the method figured out, that would be to allow them >to have a maximum number of times this event will be listed, (with a max of >say 12 for monthly events) and I will store a unique id for the initial >entry and will copy that into a parent event ID field and also have a >repeating event filed flag as well. > >The problem is how to I figure out what is the 3rd Saturday (or second >Monday etc) in order to properly place the information into the database? Thinking off the top of my head....Create a database with 5 fields and one record for every day of the year(s) i.e.,date month year dayName daynameIndex You should be able to create this fairly easily. Use the date formating and the built in day of the year code to loop through.Then when asked to create events for every third thursday you should have enough info in this database to get you the dates. -- Sam LewisSamLewis.com Tel: 626-852-0956 Fax: 916-404-5698------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Adding repeating events to a database (Sam Lewis 2001)
  2. Re: Adding repeating events to a database (Aaron Lynch 2001)
  3. Adding repeating events to a database (dale 2001)
>Hello, > >I am creating a calendar system and want users to be able to enter repeating >events. These events will most likely be something like 3rd Saturday of the >month and so forth. > >I think I have part of the method figured out, that would be to allow them >to have a maximum number of times this event will be listed, (with a max of >say 12 for monthly events) and I will store a unique id for the initial >entry and will copy that into a parent event ID field and also have a >repeating event filed flag as well. > >The problem is how to I figure out what is the 3rd Saturday (or second >Monday etc) in order to properly place the information into the database? Thinking off the top of my head....Create a database with 5 fields and one record for every day of the year(s) i.e.,date month year dayName daynameIndex You should be able to create this fairly easily. Use the date formating and the built in day of the year code to loop through.Then when asked to create events for every third thursday you should have enough info in this database to get you the dates. -- Sam LewisSamLewis.com Tel: 626-852-0956 Fax: 916-404-5698------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Sam Lewis

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:

WebDNA Solutions ... (1997) checkbox results written to a database (1999) Flash (2000) carriage returns in data (1997) Bug or syntax error on my part? (1997) emailer w/F2 (1997) Trouble with formula.db (1997) WebCat2.0 [format thousands .0f] no go (1997) ANother SHOWIF problem (1997) Multi vendor shop (2000) Nested tags count question (1997) Encrypt & SetHeader Length Problem (2000) Execute Applescript (1997) WebDNA CAPTCHA (2008) Support suggestions - Response (2000) Subtotal Not Calculated on Invoice.html (1998) [format xs] freeze (1997) How does the Globals folder work? (2000) Not reading code (1997) Help Encrypt/Decrypt eMail (2003)