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:
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
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...