Re: Reporting form..

This WebDNA talk-list message is from

2001

It keeps the original formatting. numero = 39839
interpreted = N
texte = Chas -You cannot directly perform multiple comparisons within one field in a search. There are a couple ways around this, depending on your situation.If t1, t2, etc, as well as the theme field, are singular words, you could use a word or search like this...[search db=[tRoot]db/theme.db&wothemedata=[t1]+[t2]+[t3]+[t4]+[t5]+[t6]+[t7]&themesumm=T&allreqd=T]If you've got spaces in your values this won't work though, cause if, for example, t2 contained the blues then all theme values containing the would match.Another way that would handle this situation would be to create multiple field groups which each contain only the theme field, and to search each of those field groups once. Note that you don't want allreqd=T in this case, as that would require ALL search comparisons to be true, which would never happen...[search db=[tRoot]db/theme.db&group1field=theme&group2field=theme...&eqgroup1data=[t1]&eqgroup2data=[t2]...]... Also be careful to [url] your t1, t2... values if there is any chance they contain questionable characters, like ampersands.- BrianAt 12:47 PM 11/1/2001, chas wrote:>Hi everyone,>>I'll bet this is pretty simple, could'nt find an example in the archives...>>I'm trying to set up a reporting form for customers>>the form contains fields for [t1] [t2] [t3] etc...>>I want to return the list of hits by searching db.theme>for [t1] [t2] [t3] corresponding info (up to 7 exact matches)>>>t1=[t1]>t2=[t2]>t3=[t3] [!]variables fire fine...[/!]>>[!]====== Search results ======[/!]>[search >db=[tRoot]db/theme.db&eqthemedata=[t1]&eqthemedata=[t2]&eqthemedata=[t3]&eqthemedata=[t4]&eqthemedata=[t5]&eqthemedata=[t6]&eqthemedata=[t7]&themesumm=T&allreqd=T]>>[founditems]>>>>>>>>

[theme]

[fresh]

[airtime]

[composer]

[affiliation]

[publisher]

>[/founditems]>[/search]>>Cheers Chas>>------------------------------------------------------------->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 >>Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Reporting form.. (Brian Fries 2001)
Re: Reporting form.. (Brian Fries 2001)
Reporting form.. (chas@valley.net (chas) 2001)

Chas -You cannot directly perform multiple comparisons within one field in a search. There are a couple ways around this, depending on your situation.If t1, t2, etc, as well as the theme field, are singular words, you could use a word or search like this...[search db=[tRoot]db/theme.db&wothemedata=[t1]+[t2]+[t3]+[t4]+[t5]+[t6]+[t7]&themesumm=T&allreqd=T]If you've got spaces in your values this won't work though, cause if, for example, t2 contained the blues then all theme values containing the would match.Another way that would handle this situation would be to create multiple field groups which each contain only the theme field, and to search each of those field groups once. Note that you don't want allreqd=T in this case, as that would require ALL search comparisons to be true, which would never happen...[search db=[tRoot]db/theme.db&group1field=theme&group2field=theme...&eqgroup1data=[t1]&eqgroup2data=[t2]...]... Also be careful to [url] your t1, t2... values if there is any chance they contain questionable characters, like ampersands.- BrianAt 12:47 PM 11/1/2001, chas wrote:>Hi everyone,>>I'll bet this is pretty simple, could'nt find an example in the archives...>>I'm trying to set up a reporting form for customers>>the form contains fields for [t1] [t2] [t3] etc...>>I want to return the list of hits by searching db.theme>for [t1] [t2] [t3] corresponding info (up to 7 exact matches)>>>t1=[t1]>t2=[t2]>t3=[t3] [!]variables fire fine...[/!]>>[!]====== Search results ======[/!]>[search >db=[tRoot]db/theme.db&eqthemedata=[t1]&eqthemedata=[t2]&eqthemedata=[t3]&eqthemedata=[t4]&eqthemedata=[t5]&eqthemedata=[t6]&eqthemedata=[t7]&themesumm=T&allreqd=T]>>[founditems]>>>>>>>>