The old multiple selection bit

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29822
interpreted = N
texte = I need to use multiple-selection lists for both queries and data entry.If I'm using [formvariables] to match up the form fields with their corresponding db fields, how would I ensure I could make sure each part of a multiple selection list was stored or queried?Right now, my HTML list on my add/search form looks like:The DNA processing this:[showif [action]=Append] [replace db=thing.db&eqSKUdatarq=[url][_sku][/url]&append=T] [formvariables name=_&exact=F][getchars start=2][name][/getchars] =[url][value][/url]&[/formvariables][/replace] Record Added
[commitdatabase db=thing.db] [/showif]only stores the first of the values selected.In the same way, this:[search db=thing.db&[formvariables name=_&exact=F] [getchars start=2][name][/getchars] =[url][value][/url]&[/formvariables]startat=[startat]] [numfound] record(s) matched your search.Only searches on the first value selected instead of an and/or search on each selection.-- Andrew Vernon avernon@dramatols.net------------------------------------------------------------- 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:

    
  1. Re: REPOST: The old multiple selection bit (Mike Davis 2000)
  2. REPOST: The old multiple selection bit (Andrew Vernon 2000)
  3. Re: The old multiple selection bit (Andrew Vernon 2000)
  4. Re: The old multiple selection bit (Kenneth Grome 2000)
  5. The old multiple selection bit (Andrew Vernon 2000)
I need to use multiple-selection lists for both queries and data entry.If I'm using [formvariables] to match up the form fields with their corresponding db fields, how would I ensure I could make sure each part of a multiple selection list was stored or queried?Right now, my HTML list on my add/search form looks like:The DNA processing this:[showif [action]=Append] [replace db=thing.db&eqSKUdatarq=[url][_sku][/url]&append=T] [formvariables name=_&exact=F][getchars start=2][name][/getchars] =[url][value][/url]&[/formvariables][/replace] Record Added
[commitdatabase db=thing.db] [/showif]only stores the first of the values selected.In the same way, this:[search db=thing.db&[formvariables name=_&exact=F] [getchars start=2][name][/getchars] =[url][value][/url]&[/formvariables]startat=[startat]] [numfound] record(s) matched your search.Only searches on the first value selected instead of an and/or search on each selection.-- Andrew Vernon avernon@dramatols.net------------------------------------------------------------- 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 Andrew Vernon

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:

Problems passing [SKU] with $Replace in 2.0 (1997) Forms (1998) Occasional crashes with $remove (1997) Include a big block of text (1997) WC2b15 File Corruption (1997) Attention SMSI - DOCS Error (2004) [WebDNA] RE: Using Dhl with StoreBuilder (2008) WebCat Linux: Could not create pipeKey segment (2000) old problem (2001) Help with Shipping Costs (1997) [listchars] request (was: Bug in capitalize ... ?) (2003) Re:multiple digests, please stop (1997) b12 cannot limit records returned and more. (1997) Re[2]: [REQ] Improved SQL context (2000) Eudora Plugin (1999) Still having install problems (2000) dates and hex formatting (1997) OK, here goes... (1997) PCS search results page (1998) Logging purchases (1997)