Re: [WebDNA] Displaying time specific records

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105937
interpreted = N
texte = This is a multi-part message in MIME format. --------------000607090405080904030206 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Tom, Would perhaps creating a trigger to occur everyday at 2pm to search for=20 any press release scheduled and if found then post? Steve Tom Duke wrote: > Hi all, > > Wondering how people deal with time specific records. =C2 I.e. a press=20 > release that can only be shown after 2pm on a specific day. =C2 The=20 > time restriction only applies on the day the press release is issued. > > Currently I store the dates and times in separate fields - should I be=20 > looking at using a Unix style timestamp or 'seconds since' - or is=20 > there an easier way. > > Take care > - Tom > > --=20 Steve Raslevich President/CEO Northern Sound & Light, Inc. 11 Shingiss Street McKees Rocks, Pennsylvania 15136 Phone: (412) 331-1000 Fax: (412) 331-1035 http://www.northernsound.net ------------------------------------------------------------------- This Email and any files transmitted with it contain confidential, non-pu= blic information intended solely for the use of the individual to whom or= the entity to which they are addressed. Unauthorized use, reproduction, = distribution or communication of this message or any information containe= d or attached to this message is strictly prohibited and may be unlawful.= =20 If you have received this email in error please notify the sender immedia= tely by e-mail or contact Northern Sound & Light at frontdesk@northernsou= nd.net or (412) 331-1000. ------------------------------------------------------------------- --------------000607090405080904030206 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Tom,

Would perhaps creating a trigger to occur everyday at 2pm to search for any press release scheduled and if found then post?

Steve

Tom Duke wrote: Hi all,

Wondering how people deal with time specific records.  I.e. a press release that can only be shown after 2pm on a specific day.   The time restriction only applies on the day the press release is issued.

Currently I store the dates and times in separate fields - should I be looking at using a Unix style timestamp or 'seconds since' - or is there an easier way.

Take care
- Tom



-- Steve RaslevichPresident/CEONorthern Sound & Light, Inc.11 Shingiss StreetMcKees Rocks, Pennsylvania 15136Phone: (412) 331-1000Fax: (412) 331-1035http://www.northernsound.net-------------------------------------------------------------------This Email and any files transmitted with it contain confidential, non-public information intended solely for the use of the individual to whom or the entity to which they are addressed. Unauthorized use, reproduction, distribution or communication of this message or any information contained or attached to this message is strictly prohibited and may be unlawful. If you have received this email in error please notify the sender immediately by e-mail or contact Northern Sound & Light at frontdesk@northernsound.net or (412) 331-1000.-------------------------------------------------------------------
--------------000607090405080904030206-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Displaying time specific records (Tom Duke 2010)
  2. RE: [WebDNA] Displaying time specific records ("Olin Lagon" 2010)
  3. Re: [WebDNA] Displaying time specific records (Tom Duke 2010)
  4. Re: [WebDNA] Displaying time specific records (Kenneth Grome 2010)
  5. Re: [WebDNA] Displaying time specific records (Toby Cox 2010)
  6. Re: [WebDNA] Displaying time specific records (Steve Raslevich 2010)
  7. [WebDNA] Displaying time specific records (Tom Duke 2010)
This is a multi-part message in MIME format. --------------000607090405080904030206 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Tom, Would perhaps creating a trigger to occur everyday at 2pm to search for=20 any press release scheduled and if found then post? Steve Tom Duke wrote: > Hi all, > > Wondering how people deal with time specific records. =C2 I.e. a press=20 > release that can only be shown after 2pm on a specific day. =C2 The=20 > time restriction only applies on the day the press release is issued. > > Currently I store the dates and times in separate fields - should I be=20 > looking at using a Unix style timestamp or 'seconds since' - or is=20 > there an easier way. > > Take care > - Tom > > --=20 Steve Raslevich President/CEO Northern Sound & Light, Inc. 11 Shingiss Street McKees Rocks, Pennsylvania 15136 Phone: (412) 331-1000 Fax: (412) 331-1035 http://www.northernsound.net ------------------------------------------------------------------- This Email and any files transmitted with it contain confidential, non-pu= blic information intended solely for the use of the individual to whom or= the entity to which they are addressed. Unauthorized use, reproduction, = distribution or communication of this message or any information containe= d or attached to this message is strictly prohibited and may be unlawful.= =20 If you have received this email in error please notify the sender immedia= tely by e-mail or contact Northern Sound & Light at frontdesk@northernsou= nd.net or (412) 331-1000. ------------------------------------------------------------------- --------------000607090405080904030206 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Tom,

Would perhaps creating a trigger to occur everyday at 2pm to search for any press release scheduled and if found then post?

Steve

Tom Duke wrote: Hi all,

Wondering how people deal with time specific records.  I.e. a press release that can only be shown after 2pm on a specific day.   The time restriction only applies on the day the press release is issued.

Currently I store the dates and times in separate fields - should I be looking at using a Unix style timestamp or 'seconds since' - or is there an easier way.

Take care
- Tom



-- Steve RaslevichPresident/CEONorthern Sound & Light, Inc.11 Shingiss StreetMcKees Rocks, Pennsylvania 15136Phone: (412) 331-1000Fax: (412) 331-1035http://www.northernsound.net-------------------------------------------------------------------This Email and any files transmitted with it contain confidential, non-public information intended solely for the use of the individual to whom or the entity to which they are addressed. Unauthorized use, reproduction, distribution or communication of this message or any information contained or attached to this message is strictly prohibited and may be unlawful. If you have received this email in error please notify the sender immediately by e-mail or contact Northern Sound & Light at frontdesk@northernsound.net or (412) 331-1000.-------------------------------------------------------------------
--------------000607090405080904030206-- Steve Raslevich

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:

[Webcat 2]Next (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Multiple Newcarts (1996) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Help! WebCat2 bug (1997) Loss in Form (1998) Doctype (2004) Banner DNA (1997) flushdatabases (1997) Caching pages...again (2001) Locking up with WebCatalog... (1997) WebCat2 - storing unformatted date data? (1997) [WebDNA] Internal [ipaddress] ? (2009) Replace context problem ... (1997) Re:listfiles-looking for slick solution (1997) HELP WITH DATES (1997) (2003) Bad match! (2002) Problem when Inputing text (1999) Replace/Commit not Replacing/Commiting (2000)