RE: [WebDNA] WebDNA frameworks and beginners
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108432
interpreted = N
texte = This is a multi-part message in MIME format. ------=_NextPart_000_0021_01CCE182.2E80C1D0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Aaron, This is excellent! Thank you for the detailed response. I see clearly how to proceed. 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=[some_value]&date_stamp=[date]&time_stamp=[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! ------=_NextPart_000_0021_01CCE182.2E80C1D0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
Aaron,
This is excellent! Thank you for the detailed response. I = see clearly how to proceed.
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= ]&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. =
>If you wanted to = track Date & Time Created and the Date & Time Modified, you would have to = create 4 fields.
------=_NextPart_000_0021_01CCE182.2E80C1D0--
Associated Messages, from the most recent to the oldest:
This is a multi-part message in MIME format. ------=_NextPart_000_0021_01CCE182.2E80C1D0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Aaron, This is excellent! Thank you for the detailed response. I see clearly how to proceed. 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=[some_value]&date_stamp=
[date]&time_stamp=
[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! ------=_NextPart_000_0021_01CCE182.2E80C1D0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable
Aaron,
This is excellent! Thank you for the detailed response. I = see clearly how to proceed.
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= ]&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. =
>If you wanted to = track Date & Time Created and the Date & Time Modified, you would have to = create 4 fields.
------=_NextPart_000_0021_01CCE182.2E80C1D0--
"Lori Palmquist"
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:
inconsistencies (1999)
Stopping bad HTML propagation ? (1997)
Q: writefile and uploads. (1998)
Emailer and encryption (1997)
converchars in sendmail context.... (2004)
[searchString] (1997)
Can't Update records (1997)
UPPERCASE (1997)
[OT] Theiving B*****ds (2004)
2nd WebCatalog2 Feature Request (1996)
Search/sort in URL Was: GuestBook example (1997)
WebCat website for developers and hosters (2001)
Adding non-SKUs to cart (1998)
[DOS] (1999)
WC TableGrinder (1997)
WebDNA Examples - Call for submission... (1998)
WebDNA tags in WebMerchant email templates ... (1997)
OK, here goes... (1997)
Date Sorting (1997)
requiring form fields? (2000)