Re: Form Variables
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28995
interpreted = N
texte = All the formvariables will have the name _skudata, so we use aformvariables loop to pick outvariables that begin with _sku (name=_sku&exact=F). The correspondingvalues for the formvariablesare used in the search (eqSKUdatarq=[url][value][/url]). The code willproduce a table row for each item selected.[formvariables name=_sku&exact=F][search db=Briggs.db&eqSKUdatarq=[url][value][/url]][founditems]
[SKU] | [title] | [quantity] | $[format.2f][price1][/format] | Specs | Add to Order |
[/founditems][/search][/formvariables]-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Eric palhofSent: Tuesday, March 14, 2000 7:59 AMTo: WebCatalog TalkSubject: Re: Form VariablesJohn:I hope this clarifies my problem:I am using a multiple menu (see: http://24.94.116.14/Briggs/SKU3.tpl). I amable to select from the list more than one item by holding down the controlkey or command key. The list is drawn from the database. I understand whatyour saying about searching the database and may have confused it with listdrawn from the db. I know the selections from the list are passed by usingthe form variables so what I need is a search on the database that finds themultiple selection and returns them as line items in the result page. Mycode looks like this on the search page:
My code on the result.tpl looks like this:
[foundItems][SKU] | [title] | [quantity] | $[format.2f][price1][/format] | Specs | Add to Order |
[/foundItems]Is this clear?---------->From: John Butler
>To: (WebCatalog Talk)>Subject: Re: Form Variables>Date: Tue, Mar 14, 2000, 10:42 AM>> Eric if you post your actual code then you'll get better help. But do try> to isolate> just the code that is relevant - i.e. just the part that is what you areusingto> attempt something which is not working. So in this case you would postthe> code you> are using which you think should get each found item along withdescription,price> etc. into a line item format on the result page>> You say you read the manual on [formvariables]? It does just what it says> it does -> Lists all the form variables and parameters passed to the current page.> (There's nothing in that desciption about searching a database.)>> Please just ask if something in the desciption of what [formvariables]does is> confusing to you. :-) If you are trying to search a database for recordsandthen> display data from those records on a page then you don't need> [formvariables]. People> have been suggesting you use [formvariables] just to see if you havesuccessfully> written code which will pass the name/value pairs that you DO need toconstruct a> meaningful search. Try to break your confusion down into smaller bits...since it> seems like there are several things you are not yet understanding and it's> all rolled> up into a ball and hard to unravel... For example ask me to explain whatImean if> there is something in this post which you don't understand. Be specific.>> :-)>> -John>> Eric palhof wrote:>>> I've been told form variables are only used to test and debug to see ifthe>> data is passed. What I'm attempting to do is get each found item alongwith>> description, price etc. into a line item format on the result page. Ihave>> the [foundItems] wrapped around the line items but only the first item in>> the search shows up. I want to remove the>>>> [formvariables]>> [value]
>> [/formvariables]>>>> after I get this to work correctly.>> I tried the form variables in the body where I should probably usesomething>> else to achieve my goal but I'm not sure what to do with this. If Form>> Variables are only to be used for debugging, it is not stated in themanual>> on page 126 to 128. So I'm left wondering if it is used other thantesting.>>>> ---------->> >From: Charles Kline >> >To: (WebCatalog Talk)>> >Subject: Re: Form Variables>> >Date: Tue, Mar 14, 2000, 9:12 AM>> >>>>> > what are you trying to do??>> >>> >>> >>I've tried to wrap: [formvariables] around my [search] tags but itdoesn't>> >>work. I only see the first line item. I've moved [formvariables] aroundto>> >>find the correct position but nothing works. I placed at the top of thepage>> >>and tested:>> >>[formvariables]>> >>[value]
>> >>[/formvariables]>> >>>> >>and I can see the SKU and all the items IDs. Can anyone shed some lighton>> >>this?>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
All the formvariables will have the name _skudata, so we use aformvariables loop to pick outvariables that begin with _sku (name=_sku&exact=F). The correspondingvalues for the formvariablesare used in the search (eqSKUdatarq=[url][value][/url]). The code willproduce a table row for each item selected.[formvariables name=_sku&exact=F][search db=Briggs.db&eqSKUdatarq=[url][value][/url]][founditems][SKU] | [title] | [quantity] | $[format.2f][price1][/format] | [cart]&sku=[url][sku][/url]>Specs | [cart]&db=Briggs.db&sku=[url][sku][/url]>Add to Order |
[/founditems][/search][/formvariables]-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Eric palhofSent: Tuesday, March 14, 2000 7:59 AMTo: WebCatalog TalkSubject: Re: Form VariablesJohn:I hope this clarifies my problem:I am using a multiple menu (see: http://24.94.116.14/Briggs/SKU3.tpl). I amable to select from the list more than one item by holding down the controlkey or command key. The list is drawn from the database. I understand whatyour saying about searching the database and may have confused it with listdrawn from the db. I know the selections from the list are passed by usingthe form variables so what I need is a search on the database that finds themultiple selection and returns them as line items in the result page. Mycode looks like this on the search page:My code on the result.tpl looks like this:[founditems][SKU] | [title] | [quantity] | $[format.2f][price1][/format] | [cart]&sku=[url][sku][/url]>Specs | [cart]&db=my.db&sku=[url][sku][/url]>Add to Order |
[/foundItems]Is this clear?---------->From: John Butler >To: (WebCatalog Talk)>Subject: Re: Form Variables>Date: Tue, Mar 14, 2000, 10:42 AM>> Eric if you post your actual code then you'll get better help. But do try> to isolate> just the code that is relevant - i.e. just the part that is what you areusingto> attempt something which is not working. So in this case you would postthe> code you> are using which you think should get each found item along withdescription,price> etc. into a line item format on the result page>> You say you read the manual on [formvariables]? It does just what it says> it does -> Lists all the form variables and parameters passed to the current page.> (There's nothing in that desciption about searching a database.)>> Please just ask if something in the desciption of what [formvariables]does is> confusing to you. :-) If you are trying to search a database for recordsandthen> display data from those records on a page then you don't need> [formvariables]. People> have been suggesting you use [formvariables] just to see if you havesuccessfully> written code which will pass the name/value pairs that you DO need toconstruct a> meaningful search. Try to break your confusion down into smaller bits...since it> seems like there are several things you are not yet understanding and it's> all rolled> up into a ball and hard to unravel... For example ask me to explain whatImean if> there is something in this post which you don't understand. Be specific.>> :-)>> -John>> Eric palhof wrote:>>> I've been told form variables are only used to test and debug to see ifthe>> data is passed. What I'm attempting to do is get each found item alongwith>> description, price etc. into a line item format on the result page. Ihave>> the [founditems] wrapped around the line items but only the first item in>> the search shows up. I want to remove the>>>> [formvariables]>> [value]
>> [/formvariables]>>>> after I get this to work correctly.>> I tried the form variables in the body where I should probably usesomething>> else to achieve my goal but I'm not sure what to do with this. If Form>> Variables are only to be used for debugging, it is not stated in themanual>> on page 126 to 128. So I'm left wondering if it is used other thantesting.>>>> ---------->> >From: Charles Kline >> >To: (WebCatalog Talk)>> >Subject: Re: Form Variables>> >Date: Tue, Mar 14, 2000, 9:12 AM>> >>>>> > what are you trying to do??>> >>> >>> >>I've tried to wrap: [formvariables] around my [search] tags but itdoesn't>> >>work. I only see the first line item. I've moved [formvariables] aroundto>> >>find the correct position but nothing works. I placed at the top of thepage>> >>and tested:>> >>[formvariables]>> >>[value]
>> >>[/formvariables]>> >>>> >>and I can see the SKU and all the items IDs. Can anyone shed some lighton>> >>this?>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
WebDNA Support
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:
calculating tax rates, mail order solutions and version 2 (1997)
Shopping carts and reloading pages (1997)
Associative lookup style? + bit more (1997)
New Install (2003)
What am I doing wrong? (2000)
The code, one more time. (2003)
RE: [WebDNA] Sorting -- Dealing with Blanks (2008)
WebCatalog Use Question (1997)
ReturnRaw context (1997)
Trigger: Only on Saturday (2001)
[SearchString] problem with [search] context (1997)
[WebDNA] Cheers (2008)
Snake Bites (1997)
RE: [WebDNA] Test (2008)
(2001)
RE: [WebDNA] Random Numbers no repeat within a range (2014)
More DateMath problems (1997)
What am I missing (1997)
Wait, I forgot something! (was authenticating a seconduser, the sequel) (1997)
Major problem (1999)