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:

X Server (1999) New syntax feedback for 4.0 (2000) Unknown error: OrderNotCreated (1997) Multiple cart additions (1997) Using Applescript to process WebCatalog functions (1998) [WebDNA] Variable truncating when using javascript openwindow (2011) Separate server for jpg/gif files (1998) [WebDNA] New problem with [ShowNext] (2010) Merging databases (1997) Please post more "exceptions to the rules" ... (2005) Claris HomePage messes up the code (1997) Banner Ads (2000) Location of Browser Info.txt file (1997) ShowNext (1997) How is it done? (1998) ShowCart (2001) $Replace with [founditems] (1997) [WebDNA] mac osx permissions problem (2010) [WebDNA] lookup in tables defined in functions - bug? (2016) Practical Uses (2003)