numero = 18675
interpreted = N
texte = >> >> SALUTATION:>> >> CONTACT:>> >>>> >> How would I request that both SALUTATION and CONTACT field match each input>> >> exactly in a search request before returning only the db record containing>> >> each?>>>> >Your syntax is correct; just ditch the _s before the eqs and it should>> >work.>>>> That's fine; he's setting it up for the real search on the next page using>> form variables to collect anything starting with _>I'm not getting the point of this syntax. Wouldn't the _s screw up>everything?Normally yes it would, because usually when you're creating variables that look something like these -- but *without* the leading _ character -- it's because you're sending a search command directly from the form itself. But in this case the leading _ characters would prevent a search command in the form from working properly (as you have recognized) so we have to assume that he's passing these variables to the next page so they can be used in a search context.>And what does [formVariables] have to do with it?On the next page, he's probably using a technique like the following. I've broken this down into separate lines for better visual clarity, but in reality all the WebDNA code here must appear on one line without any carriage returns:[search db=xxx.db[formvariables][showif [value]~_]&[name]=[getchars start=2][value][/getchars][/showif][/formvariables]]Basically it's a method useful for separating the formvariables you *want* included the search from the ones you do NOT want in the search.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>> >> SALUTATION:>> >> CONTACT:>> >>>> >> How would I request that both SALUTATION and CONTACT field match each input>> >> exactly in a search request before returning only the db record containing>> >> each?>>>> >Your syntax is correct; just ditch the _s before the eqs and it should>> >work.>>>> That's fine; he's setting it up for the real search on the next page using>> form variables to collect anything starting with _>I'm not getting the point of this syntax. Wouldn't the _s screw up>everything?Normally yes it would, because usually when you're creating variables that look something like these -- but *without* the leading _ character -- it's because you're sending a search command directly from the form itself. But in this case the leading _ characters would prevent a search command in the form from working properly (as you have recognized) so we have to assume that he's passing these variables to the next page so they can be used in a search context.>And what does [formvariables] have to do with it?On the next page, he's probably using a technique like the following. I've broken this down into separate lines for better visual clarity, but in reality all the WebDNA code here must appear on one line without any carriage returns:[search db=xxx.db[formvariables][showif [value]~_]&[name]=[getchars start=2][value][/getchars][/showif][/formvariables]]Basically it's a method useful for separating the formvariables you *want* included the search from the ones you do NOT want in the search.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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...