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.--------------000607090405080904030206Content-Type: text/plain; charset=ISO-8859-1; format=flowedContent-Transfer-Encoding: quoted-printableTom,Would perhaps creating a trigger to occur everyday at 2pm to search for=20any press release scheduled and if found then post?SteveTom 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>>--=20Steve 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-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.==20If 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.---------------------------------------------------------------------------------000607090405080904030206Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: 7bit
Tom,
Would perhaps creating a trigger to occur everyday at 2pm to search forany press release scheduled and if found then post?
Steve
Tom Duke wrote:
Hi all,
Wondering how people deal with time specific records. Â I.e. apress release that can only be shown after 2pm on a specific day. Â The time restriction only applies on the day the press release isissued.
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:
This is a multi-part message in MIME format.--------------000607090405080904030206Content-Type: text/plain; charset=ISO-8859-1; format=flowedContent-Transfer-Encoding: quoted-printableTom,Would perhaps creating a trigger to occur everyday at 2pm to search for=20any press release scheduled and if found then post?SteveTom 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>>--=20Steve 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-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.==20If 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.---------------------------------------------------------------------------------000607090405080904030206Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: 7bit
Tom,
Would perhaps creating a trigger to occur everyday at 2pm to search forany press release scheduled and if found then post?
Steve
Tom Duke wrote:
Hi all,
Wondering how people deal with time specific records. Â I.e. apress release that can only be shown after 2pm on a specific day. Â The time restriction only applies on the day the press release isissued.
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)