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 a formvariables loop to pick out variables that begin with _sku (name=_sku&exact=F). The corresponding values for the formvariables are used in the search (eqSKUdatarq=[url][value][/url]). The code will produce 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]On Behalf Of Eric palhof Sent: Tuesday, March 14, 2000 7:59 AM To: WebCatalog Talk Subject: Re: Form Variables John: I hope this clarifies my problem: I am using a multiple menu (see: http://24.94.116.14/Briggs/SKU3.tpl). I am able to select from the list more than one item by holding down the control key or command key. The list is drawn from the database. I understand what your saying about searching the database and may have confused it with list drawn from the db. I know the selections from the list are passed by using the form variables so what I need is a search on the database that finds the multiple selection and returns them as line items in the result page. My code 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 are using to > attempt something which is not working. So in this case you would post the > code you > are using which you think should get each found item along with description, 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 records and then > 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 have successfully > written code which will pass the name/value pairs that you DO need to construct 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 what I mean 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 if the >> data is passed. What I'm attempting to do is get each found item along with >> description, price etc. into a line item format on the result page. I have >> 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 use something >> 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 the manual >> on page 126 to 128. So I'm left wondering if it is used other than testing. >> >> ---------- >> >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 it doesn't >> >>work. I only see the first line item. I've moved [formvariables] around to >> >>find the correct position but nothing works. I placed at the top of the page >> >>and tested: >> >>[formvariables] >> >>[value]
>> >>[/formvariables] >> >> >> >>and I can see the SKU and all the items IDs. Can anyone shed some light on >> >>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 a formvariables loop to pick out variables that begin with _sku (name=_sku&exact=F). The corresponding values for the formvariables are used in the search (eqSKUdatarq=[url][value][/url]). The code will produce 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]On Behalf Of Eric palhof Sent: Tuesday, March 14, 2000 7:59 AM To: WebCatalog Talk Subject: Re: Form Variables John: I hope this clarifies my problem: I am using a multiple menu (see: http://24.94.116.14/Briggs/SKU3.tpl). I am able to select from the list more than one item by holding down the control key or command key. The list is drawn from the database. I understand what your saying about searching the database and may have confused it with list drawn from the db. I know the selections from the list are passed by using the form variables so what I need is a search on the database that finds the multiple selection and returns them as line items in the result page. My code 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 are using to > attempt something which is not working. So in this case you would post the > code you > are using which you think should get each found item along with description, 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 records and then > 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 have successfully > written code which will pass the name/value pairs that you DO need to construct 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 what I mean 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 if the >> data is passed. What I'm attempting to do is get each found item along with >> description, price etc. into a line item format on the result page. I have >> 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 use something >> 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 the manual >> on page 126 to 128. So I'm left wondering if it is used other than testing. >> >> ---------- >> >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 it doesn't >> >>work. I only see the first line item. I've moved [formvariables] around to >> >>find the correct position but nothing works. I placed at the top of the page >> >>and tested: >> >>[formvariables] >> >>[value]
>> >>[/formvariables] >> >> >> >>and I can see the SKU and all the items IDs. Can anyone shed some light on >> >>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:
Date fun with MySQL (2004)
Unexpected error (1997)
Purchased cart being overwritten - still !?? (1997)
Further tests with the infamous shipCost (1997)
When do we get to request new features? (1999)
[redirect] question (2005)
build a select list from a db search (2004)
[include] affect on filepaths for links? (1997)
Mac OS X Server, Apache etc etc (1999)
Its slow.... (2004)
HomePage Caution (1997)
Custom formulas.db (1998)
Migrating to NT (1997)
test (2003)
Re[2]: Next X hits (1996)
Separate SSL Server (1997)
RE: type 2 errors with ssl server (1997)
Setting the Date (2000)
Bug or syntax error on my part? (1997)
Emailer Set Up (1997)