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:
Separate SSL Server (1997)
Calculating Total QTY (1998)
international time (1997)
[WebDNA] Timestamp Converter (2015)
Re:quit command on NT (1997)
Help wanted (1998)
multi condition with showif (2005)
More than one db with the same namn (was: WC2f3) (1997)
Questions (1998)
Hiding HTML and page breaks (1997)
Pre-flight public flag (1997)
Hard Questions ? (1997)
Converting SQL Microtime to Date and Time (2003)
Multiple Merchant Accounts? (1997)
[BULK] [WebDNA] PayPal Integration (2017)
InSecureTextVariables.... (2000)
(1997)
Include a big block of text (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Can't Update records (1997)