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:

[WebDNA] Search Problem (2011) Security hole in WebCat? (1999) Unusual characters in the db ... (2002) Non-Cart Files in Shopping Cart Folder (1997) Webdna keeps dying... (2003) Form/HTML Help (2000) Template not found error messages (1997) MacAuthorize Hub/Client and program linking (1997) problems with 2 tags (1997) [format 40s]text[/format] doesn't work (1997) Help name our technology! (1997) PSC recommends what date format yr 2000??? (1997) Robots fill event log (1997) Catalogs and W* (1996) Beta version-Mac? (was Emailer update for Mac?) (1998) Weird Problem (1997) WebCat2: Items xx to xx shown, etc. (1997) listfiles shows invisible files ... (1999) Follow-up to listfiles bug report ... (2003) Protect (1997)