Re: [WebDNA] WebDNA frameworks and beginners

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108428
interpreted = N
texte = --Apple-Mail=_F88153A8-825E-4678-A1BD-7DEAD658F320 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 Hi Lori, Essentially, if you want to be able to track the date and/or time that = your records are created and/or modified, you need to 'timestamp' your = records. WebDNA doesn't do this automatically, whereas I know that some = other frameworks do this with MySQL. =20 Now keep in mind that you are creating this feature manually, there is = no native syntax for automatic time stamping of database records. So = make sure that you don't use 'date' or 'time' as your field names since = these are reserved tags. You could create two new fields in your db = named 'date_stamp' and 'time_stamp'. Then, every time you write to the database, add this between your = [append] or [replace] tags: ...your_var=3D[some_value]&date_stamp=3D[date]&time_stamp=3D[time].... Now you have the ability to add criteria to your searches to filter = results based on the date and time they were last modified. However, if = you already had records in your database before adding the timestamp = fields, they will have empty values. =20 If you wanted to track Date & Time Created and the Date & Time Modified, = you would have to create 4 fields. Hope this helps! On Feb 2, 2012, at 10:15 AM, Lori Palmquist wrote: > Bill, > =20 > I don=92t have a date field. If I created one, would the correct date = automatically appear? > =20 > Lori > =20 > =20 > >Do you have a date field in the database? If so, what is its name = and can you provide the format of the stored dates? > =20 > >If you do not have the date stored, I don't think this is easily = done. =20 > =20 > >Bill=20 > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_F88153A8-825E-4678-A1BD-7DEAD658F320 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 Hi Lori,

Essentially, if you = want to be able to track the date and/or time that your records are = created and/or modified, you need to 'timestamp' your records. =  WebDNA doesn't do this automatically, whereas I know that some = other frameworks do this with MySQL.  

Now = keep in mind that you are creating this feature manually, there is no = native syntax for automatic time stamping of database records.  So = make sure that you don't use 'date' or 'time' as your field names since = these are reserved tags.  You could create two new fields in your = db named 'date_stamp' and 'time_stamp'.

Then, = every time you write to the database, add this between your [append] or = [replace] = tags:
...your_var=3D[some_value]&date_stamp=3D[date]&tim= e_stamp=3D[time]....

Now you have the ability = to add criteria to your searches to filter results based on the date and = time they were last modified.  However, if you already had records = in your database before adding the timestamp fields, they will have = empty values.  

If you wanted to track = Date & Time Created and the Date & Time Modified, you would have = to create 4 fields.

Hope this = helps!


On Feb 2, 2012, at 10:15 = AM, Lori Palmquist wrote:

Bill,
 
I don=92t= have a date field. If I created one, would the correct date = automatically appear?
 
Lori
 
 
>Do you have a date field in the database?  If = so, what is its name and can you provide the format of the stored = dates?
 
>If you do not have the date stored, I don't think = this is easily done.  
 
>Bill 
 
-------------------------------------------= -------------- This message is sent to you because you are subscribed to = the mailing list . To = unsubscribe, E-mail to: archive= s: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_F88153A8-825E-4678-A1BD-7DEAD658F320-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] WebDNA frameworks and beginners (Govinda 2012)
  2. RE: [WebDNA] WebDNA frameworks and beginners ("Lori Palmquist" 2012)
  3. Re: [WebDNA] WebDNA frameworks and beginners (aaronmichaelmusic@gmail.com 2012)
  4. RE: [WebDNA] WebDNA frameworks and beginners ("Lori Palmquist" 2012)
  5. Re: [WebDNA] WebDNA frameworks and beginners (William DeVaul 2012)
  6. [WebDNA] WebDNA frameworks and beginners ("Lori Palmquist" 2012)
--Apple-Mail=_F88153A8-825E-4678-A1BD-7DEAD658F320 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 Hi Lori, Essentially, if you want to be able to track the date and/or time that = your records are created and/or modified, you need to 'timestamp' your = records. WebDNA doesn't do this automatically, whereas I know that some = other frameworks do this with MySQL. =20 Now keep in mind that you are creating this feature manually, there is = no native syntax for automatic time stamping of database records. So = make sure that you don't use 'date' or 'time' as your field names since = these are reserved tags. You could create two new fields in your db = named 'date_stamp' and 'time_stamp'. Then, every time you write to the database, add this between your = [append] or [replace] tags: ...your_var=3D[some_value]&date_stamp=3D[date]&time_stamp=3D[time].... Now you have the ability to add criteria to your searches to filter = results based on the date and time they were last modified. However, if = you already had records in your database before adding the timestamp = fields, they will have empty values. =20 If you wanted to track Date & Time Created and the Date & Time Modified, = you would have to create 4 fields. Hope this helps! On Feb 2, 2012, at 10:15 AM, Lori Palmquist wrote: > Bill, > =20 > I don=92t have a date field. If I created one, would the correct date = automatically appear? > =20 > Lori > =20 > =20 > >Do you have a date field in the database? If so, what is its name = and can you provide the format of the stored dates? > =20 > >If you do not have the date stored, I don't think this is easily = done. =20 > =20 > >Bill=20 > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_F88153A8-825E-4678-A1BD-7DEAD658F320 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 Hi Lori,

Essentially, if you = want to be able to track the date and/or time that your records are = created and/or modified, you need to 'timestamp' your records. =  WebDNA doesn't do this automatically, whereas I know that some = other frameworks do this with MySQL.  

Now = keep in mind that you are creating this feature manually, there is no = native syntax for automatic time stamping of database records.  So = make sure that you don't use 'date' or 'time' as your field names since = these are reserved tags.  You could create two new fields in your = db named 'date_stamp' and 'time_stamp'.

Then, = every time you write to the database, add this between your [append] or = [replace] = tags:
...your_var=3D[some_value]&date_stamp=3D[date]&tim= e_stamp=3D[time]....

Now you have the ability = to add criteria to your searches to filter results based on the date and = time they were last modified.  However, if you already had records = in your database before adding the timestamp fields, they will have = empty values.  

If you wanted to track = Date & Time Created and the Date & Time Modified, you would have = to create 4 fields.

Hope this = helps!


On Feb 2, 2012, at 10:15 = AM, Lori Palmquist wrote:

Bill,
 
I don=92t= have a date field. If I created one, would the correct date = automatically appear?
 
Lori
 
 
>Do you have a date field in the database?  If = so, what is its name and can you provide the format of the stored = dates?
 
>If you do not have the date stored, I don't think = this is easily done.  
 
>Bill 
 
-------------------------------------------= -------------- This message is sent to you because you are subscribed to = the mailing list . To = unsubscribe, E-mail to: archive= s: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_F88153A8-825E-4678-A1BD-7DEAD658F320-- aaronmichaelmusic@gmail.com

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:

about this server and links to who (1997) Mac v. NT (1998) [Off] Netscape Display Problem (1998) Format of Required fields error message (1997) Great product and great job ! (1997) OFF-TOPIC: Check www.godaddy.com for me ... (2003) WildWEBCAT98 Voting is OPEN! (1999) webcat page crashes MSIE 5 on mac (2000) upgrading (1997) calender with business days (1998) Redirecting some image requests ... (2003) Upgrading old WebCat Database Files (1997) Cobalt and WebCatalog, do they work together? (2000) High ASCII inside [LOOKUP] inside [LISTWORDS] (1998) Grepping URL-Encoded Text (2004) WebCat2b15MacPlugin - showing [math] (1997) [format xs] freeze (1997) [WebDNA] New Mountain Lion OSX Server (2013) Using WebCat for product info requests (1997) SmithMicro FTP problems (2002)