Re: [WebDNA] Looking for Govinda
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106839
interpreted = N
texte = Hi Lori Not sure what happened with the forum (?)..but anyway you'll enjoy it = here because more people hang out here and help and share tips. :-) Just address everyone when you need help and someone is likely to jump = in.. or at least ask you to clarify so they can understand what you are = stuck on. As for me, I am in and out these days.. mostly out.. so in case it ever = happens that no one else replies.. and I seem to be out.. it just means = I need another half day or whole day+ to reply. (We are packing/moving = here now.) First off, I am guessing you need to study more HTML (1) to understand = how some of the plain HTML tags work.. to then know how to use webdna = to generate them 'on the fly' (3) (dynamically). =20 Also tell me if you understand (or just note) what is in (2) below. (1) - read up on tables if you need to know how they work. Here is a = good place to study them: http://www.w3schools.com/html/html_tables.asp ..and here you will discover what that "
[plantName]" was for: HTML lists: http://www.w3schools.com/html/html_lists.asp Basically, if you want a list to be replaced by a table then you need to = swap list items (
...) for table rows (
| ... |
). The
...
is the wrapper that defines that we are creating an = (ordered) list. While the
is the wrapper that = defines that we are creating a table... but those wrappers do not show = any content directly. It is the tags *inside* the wrappers that have = the job of showing data in itemized fashion. Do play with the = "Try-It-Yourself Examples" on the www.w3schools.com site. ..and notice = what a resource that site is for you! Not just HTML!... but later CSS, = javascript.. all kinds of things you may need sooner or later. (2) - OK, now here is something that you just simply MUST wrap your head = around if you want to really get anywhere with Webdna or any server side = web language: When a user tries to go to an URL in his/her browser.. clicks a link... = submits a form.. anything.. then their browser requests the page from = the server. The server takes a look at the extension of the page (e.g. = ".html", or ".tpl", ".dna").. and then decides what to do with the = page.. whether to serve it straight to the browser, as is.. or else to = first send to another piece of software, before then sending to the = browser. In the case of your ".tpl" page on your host server.. the = server is saying, "hey these are .tpl pages.. and I am supposed to hand = these off to the webdna engine/parser before finally handing over to the = browser.... so that is what happens. The file goes to webdna where the = webdna "parser" evaluates all the webdna tags.. replaces those tags = (like e.g. "[date]") with whatever they are supposed to do (like e.g. = just stick in today's date, "07/01/2011").. and then once all the webdna = tags are evaluated (all the work they do is done, and all appropriate = output is written into the file at the spots where those tags were), = then the server finally hands the resultant text file to the browser. (3) - The discussion in (2) above can be seen in examples here: say we have this code: ---------------------------------------------------------------- [loop start=3D1&end=3D3&advance=3D1] Hi Lori!=20 [/loop]
[loop start=3D1&end=3D5&advance=3D1] - [index]
[/loop]
---------------------------------------------------------------- It produces this in the browser: ---------------------------------------------------------------- Hi Lori! Hi Lori! Hi Lori! a. 1 b. 2 c. 3 d. 4 e. 5 ---------------------------------------------------------------- Why? Because webdna gets the raw code and evaluates the webdna tags.. = and then hands whatever is the final output to the browser. If the = webdna parser ("webdna") did not evaluate the webdna tags, then you = would get this in your browser: ---------------------------------------------------------------- [loop start=3D1&end=3D3&advance=3D1] Hi Lori!=20 [/loop]
[loop start=3D1&end=3D5&advance=3D1] - [index]
[/loop]
---------------------------------------------------------------- ...just the same characters as you see in your source file when you are = editing it. (By the way (BTW) what are you using to edit your files? A = text editor?.. which one?) But when webdna does evaluate that code.. then it does whatever is = inside the [loop]...[/loop] webdna context as many times as you have = told it to (see here: http://www.webdna.us/page.dna?numero=3D245) ... = and upon each "iteration" (loop), some webdna tags *inside* the = [loop]...[/loop] change value. Like for example the [index] tag = changes its value to the number corresponding to the number of the = iteration that it is on (that it is currently looping on)... so = "
[index]" becomes "
1" on the first loop, "
2" = on the second loop, "
3" on the third loop, and so on. You can = inspect the final source code (HTML) that the browser receives (whatever = was left after webdna was done evaluating the file).. in your browser by = selecting the appropriate command in your browser which allows you to do = that. Which browser are you using? I use firefox for most of my = development.. and so the command to see the source HTML *in the browser* = (after webdna is done with it) is: View > Page Source (or command-U on a mac). If you look in whatever browser you are using (if not firefox) then you = will easily find the equivalent command (maybe called 'View Source' or = some such thing). When I view the page's source HTML (what webdna output to the browser) = for my sample code above, then I see this: ---------------------------------------------------------------- Hi Lori!=20 Hi Lori!=20 Hi Lori!=20
=09 - 1
=09 - 2
=09 - 3
=09 - 4
=09 - 5
=09
---------------------------------------------------------------- ...which *rendered* in the regular browser window looks like this: ---------------------------------------------------------------- Hi Lori! Hi Lori! Hi Lori! a. 1 b. 2 c. 3 d. 4 e. 5 ---------------------------------------------------------------- Do you understand this *perfectly*? If not, then, for now, stop all development of your website. ... and read the docs here: www.w3schools.com=20 ...and here: http://www.webdna.us/page.dna?numero=3D1 ..and ask questions here (on this webdna talklist (e-mailing list)) ..until you do get the above absolutely perfectly. What exactly do you not understand in the above discussion? THEN we can better answer your questions (in your previous email, = below). If I even understand what you have done since we were last chatting on = the forum, then I would say: sticking: "
| waterUse> | BotanicalName> | CommonName> | Exposure> |
" ..inside a [foundItems] loop is just going to output that exact static = text as many times as the number of records that the [search..] finds. = Right? If you want data from a database to be inserted while looping on a = [foundItems] loop, then you need to use square brackets ("[" and "]") .. = around the database field names whose data you want to output. To "automatically" purge old data from a database, a webdna trigger can = be just what you need. You can read about them here: http://www.webdna.us/page.dna?numero=3D290 Basically a webdna trigger is just a way you can cause some webdna code = to be evaluated on a regular time schedule, that you determine. =20 But before tackling that, you probably need to learn how to delete data = from a database in the first place. Have you yet even tried a manual = delete? Like say a user builds a plant list.. and then realizes they added some = plant that they did not want in their list.. why not give them a link = within the table row for that plant in their final list.. which they can = click to delete just that one item (plant) from their list.. and then = show them the resultant (modified) plant list. Try it! Also, when you ask for help.. always post the full code for what you are = needing help with. By "full" I do not mean the entirety of the file = (unless asked for that).. but I mean all of the *relevant* code for what = you are working on (what you are trying to do that is not working). = ... AND the resultant static text that is that code's output. See my = examples above to get a feel for that. If you are not sure.. then just try and know that there is lots of = forgiveness for anyone sincerely trying. :-) Just embarrass yourself and be really blunt while saying just where you = are with it. ;-) There always will be someone above you and someone below.. same for = every one of us here. -Govinda P.S. A forum (or talklist) "thread" refers to a series of back and = forth messages (by 2 or more users) under one subject line (usually one = topic). That is not a string. A "string", in coders terms, refers to a = series of characters... like your name is the string "L" + "o" + "r" + = "i" =3D "Lori" There are 4 characters in that string. = "3hf85g3jb$G*^\)*" is another string, 16 characters in length. P.P.S. I just looked up and saw the time. LOL. Now my wife is either = fast asleep or also Looking for Govinda. Bless her. > What do you mean "unable to continue a string I had going with = Govinda on the WebDNA Html Forum"? Did the forum stop working for you? = I'm the overworked guy who has to fix it :-) >=20 > Thanks, > -Dan >=20 > On 6/30/2011 12:36 PM, Lori Palmquist wrote: >> I was unable to continue a string I had going with Govinda on the = WebDNA Html Forum, so I=92m looking for him here. Following is the = message for him: >> =20 >> Hi Govinda, >> =20 >> I have a couple more questions for you: >> 1. How can I have the plantlist results show up in the form of a = table, instead of an ordered list? I tried changing the
tags = to
tags, then I inserted the following after = all the "switch" and "case" code within [foundItems]: >>
>> | waterUse> | >> BotanicalName> | >> CommonName> | >> Exposure> | >>
>> =20 >> I wasn't quite sure what to do with the following code, however, so I = left it: >>
[plantName] >> =20 >> This strategy didn=92t work, however. >> =20 >> =20 >> 2. Is there a way to automatically purge old data from the = Usersplantlists database? I don't need to keep this data after the = initial visit where the user creates, then prints the list. >> =20 >> Lori >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =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 > --------------------------------------------------------- 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 - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk
Associated Messages, from the most recent to the oldest:
Hi Lori Not sure what happened with the forum (?)..but anyway you'll enjoy it = here because more people hang out here and help and share tips. :-) Just address everyone when you need help and someone is likely to jump = in.. or at least ask you to clarify so they can understand what you are = stuck on. As for me, I am in and out these days.. mostly out.. so in case it ever = happens that no one else replies.. and I seem to be out.. it just means = I need another half day or whole day+ to reply. (We are packing/moving = here now.) First off, I am guessing you need to study more HTML (1) to understand = how some of the plain HTML tags work.. to then know how to use webdna = to generate them 'on the fly' (3) (dynamically). =20 Also tell me if you understand (or just note) what is in (2) below. (1) - read up on tables if you need to know how they work. Here is a = good place to study them: http://www.w3schools.com/html/html_tables.asp ..and here you will discover what that "
[plantName]" was for: HTML lists: http://www.w3schools.com/html/html_lists.asp Basically, if you want a list to be replaced by a table then you need to = swap list items (
...) for table rows (
| ... |
). The
...
is the wrapper that defines that we are creating an = (ordered) list. While the
is the wrapper that = defines that we are creating a table... but those wrappers do not show = any content directly. It is the tags *inside* the wrappers that have = the job of showing data in itemized fashion. Do play with the = "Try-It-Yourself Examples" on the www.w3schools.com site. ..and notice = what a resource that site is for you! Not just HTML!... but later CSS, = javascript.. all kinds of things you may need sooner or later. (2) - OK, now here is something that you just simply MUST wrap your head = around if you want to really get anywhere with Webdna or any server side = web language: When a user tries to go to an URL in his/her browser.. clicks a link... = submits a form.. anything.. then their browser requests the page from = the server. The server takes a look at the extension of the page (e.g. = ".html", or ".tpl", ".dna").. and then decides what to do with the = page.. whether to serve it straight to the browser, as is.. or else to = first send to another piece of software, before then sending to the = browser. In the case of your ".tpl" page on your host server.. the = server is saying, "hey these are .tpl pages.. and I am supposed to hand = these off to the webdna engine/parser before finally handing over to the = browser.... so that is what happens. The file goes to webdna where the = webdna "parser" evaluates all the webdna tags.. replaces those tags = (like e.g. "
[date]") with whatever they are supposed to do (like e.g. = just stick in today's date, "07/01/2011").. and then once all the webdna = tags are evaluated (all the work they do is done, and all appropriate = output is written into the file at the spots where those tags were), = then the server finally hands the resultant text file to the browser. (3) - The discussion in (2) above can be seen in examples here: say we have this code: ---------------------------------------------------------------- [loop start=3D1&end=3D3&advance=3D1] Hi Lori!=20 [/loop]
[loop start=3D1&end=3D5&advance=3D1] - [index]
[/loop]
---------------------------------------------------------------- It produces this in the browser: ---------------------------------------------------------------- Hi Lori! Hi Lori! Hi Lori! a. 1 b. 2 c. 3 d. 4 e. 5 ---------------------------------------------------------------- Why? Because webdna gets the raw code and evaluates the webdna tags.. = and then hands whatever is the final output to the browser. If the = webdna parser ("webdna") did not evaluate the webdna tags, then you = would get this in your browser: ---------------------------------------------------------------- [loop start=3D1&end=3D3&advance=3D1] Hi Lori!=20 [/loop]
[loop start=3D1&end=3D5&advance=3D1] - [index]
[/loop]
---------------------------------------------------------------- ...just the same characters as you see in your source file when you are = editing it. (By the way (BTW) what are you using to edit your files? A = text editor?.. which one?) But when webdna does evaluate that code.. then it does whatever is = inside the
[loop]...[/loop] webdna context as many times as you have = told it to (see here: http://www.webdna.us/page.dna?numero=3D245) ... = and upon each "iteration" (loop), some webdna tags *inside* the =
[loop]...[/loop] change value. Like for example the [index] tag = changes its value to the number corresponding to the number of the = iteration that it is on (that it is currently looping on)... so = "
[index]" becomes "
1" on the first loop, "
2" = on the second loop, "
3" on the third loop, and so on. You can = inspect the final source code (HTML) that the browser receives (whatever = was left after webdna was done evaluating the file).. in your browser by = selecting the appropriate command in your browser which allows you to do = that. Which browser are you using? I use firefox for most of my = development.. and so the command to see the source HTML *in the browser* = (after webdna is done with it) is: View > Page Source (or command-U on a mac). If you look in whatever browser you are using (if not firefox) then you = will easily find the equivalent command (maybe called 'View Source' or = some such thing). When I view the page's source HTML (what webdna output to the browser) = for my sample code above, then I see this: ---------------------------------------------------------------- Hi Lori!=20 Hi Lori!=20 Hi Lori!=20
=09 - 1
=09 - 2
=09 - 3
=09 - 4
=09 - 5
=09
---------------------------------------------------------------- ...which *rendered* in the regular browser window looks like this: ---------------------------------------------------------------- Hi Lori! Hi Lori! Hi Lori! a. 1 b. 2 c. 3 d. 4 e. 5 ---------------------------------------------------------------- Do you understand this *perfectly*? If not, then, for now, stop all development of your website. ... and read the docs here: www.w3schools.com=20 ...and here: http://www.webdna.us/page.dna?numero=3D1 ..and ask questions here (on this webdna talklist (e-mailing list)) ..until you do get the above absolutely perfectly. What exactly do you not understand in the above discussion? THEN we can better answer your questions (in your previous email, = below). If I even understand what you have done since we were last chatting on = the forum, then I would say: sticking: "
| waterUse> | BotanicalName> | CommonName> | Exposure> |
" ..inside a
[founditems] loop is just going to output that exact static = text as many times as the number of records that the [search..] finds. = Right? If you want data from a database to be inserted while looping on a =
[founditems] loop, then you need to use square brackets ("[" and "]") .. = around the database field names whose data you want to output. To "automatically" purge old data from a database, a webdna trigger can = be just what you need. You can read about them here: http://www.webdna.us/page.dna?numero=3D290 Basically a webdna trigger is just a way you can cause some webdna code = to be evaluated on a regular time schedule, that you determine. =20 But before tackling that, you probably need to learn how to delete data = from a database in the first place. Have you yet even tried a manual = delete? Like say a user builds a plant list.. and then realizes they added some = plant that they did not want in their list.. why not give them a link = within the table row for that plant in their final list.. which they can = click to delete just that one item (plant) from their list.. and then = show them the resultant (modified) plant list. Try it! Also, when you ask for help.. always post the full code for what you are = needing help with. By "full" I do not mean the entirety of the file = (unless asked for that).. but I mean all of the *relevant* code for what = you are working on (what you are trying to do that is not working). = ... AND the resultant static text that is that code's output. See my = examples above to get a feel for that. If you are not sure.. then just try and know that there is lots of = forgiveness for anyone sincerely trying. :-) Just embarrass yourself and be really blunt while saying just where you = are with it. ;-) There always will be someone above you and someone below.. same for = every one of us here. -Govinda P.S. A forum (or talklist) "thread" refers to a series of back and = forth messages (by 2 or more users) under one subject line (usually one = topic). That is not a string. A "string", in coders terms, refers to a = series of characters... like your name is the string "L" + "o" + "r" + = "i" =3D "Lori" There are 4 characters in that string. = "3hf85g3jb$G*^\)*" is another string, 16 characters in length. P.P.S. I just looked up and saw the time. LOL. Now my wife is either = fast asleep or also Looking for Govinda. Bless her. > What do you mean "unable to continue a string I had going with = Govinda on the WebDNA Html Forum"? Did the forum stop working for you? = I'm the overworked guy who has to fix it :-) >=20 > Thanks, > -Dan >=20 > On 6/30/2011 12:36 PM, Lori Palmquist wrote: >> I was unable to continue a string I had going with Govinda on the = WebDNA Html Forum, so I=92m looking for him here. Following is the = message for him: >> =20 >> Hi Govinda, >> =20 >> I have a couple more questions for you: >> 1. How can I have the plantlist results show up in the form of a = table, instead of an ordered list? I tried changing the
tags = to
tags, then I inserted the following after = all the "switch" and "case" code within
[founditems]: >>
>> | waterUse> | >> BotanicalName> | >> CommonName> | >> Exposure> | >>
>> =20 >> I wasn't quite sure what to do with the following code, however, so I = left it: >>
[plantName] >> =20 >> This strategy didn=92t work, however. >> =20 >> =20 >> 2. Is there a way to automatically purge old data from the = Usersplantlists database? I don't need to keep this data after the = initial visit where the user creates, then prints the list. >> =20 >> Lori >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =20 >> =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 > --------------------------------------------------------- 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 - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk
Govinda
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:
WC TableGrinder (1997)
Answer: WebDelivery downloads alias, not original ? (1997)
Cookies (1999)
Where is f2? (1997)
FW: weird problem (2004)
Search Engine questions ... (2002)
File perms (2002)
WebCat2b15MacPlugin - showing [math] (1997)
Need some Java Script Code (2003)
Https not showing products (2004)
multipart (2004)
database files in secure folder (1997)
HELP WITH DATES (1997)
newbie question about zip code search (2003)
[protect admin] (1997)
Nested tags count question (1997)
[price] maddness (2002)
Limiting user access to .tmpl files (1997)
Format question (2001)
Line items in table cells (1997)