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:
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.
--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!