Re: Search 1 Field Twice?

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55506
interpreted = N
texte = Jesse Proudman wrote: [snip] > Here's the full search: > > [text show=f]allowedforums=[search > db=^DNAforum/DNAforums.db&eqKEYdatarq=[url][dnakey][/url][if > "[allowedgroups]"=""][then]&eqFORUMVISGdatarq=[blank][/ > then][else]&group1field=FORUMVISG&wogroup1data=[allowedgroups]&group2fie > ld=FORUMVISG&eqGROUP2data=[blank][/else][/ > if]&GROUP1word=ww&GROUP1wbrk=,&leforumlvldatarq=[userlvl]&FORUMLVLtype=n > umber][founditems][forumid],[/founditems][/search][/text] Hi Jesse, I re-wrote your code so that the list could see it better and I agree with Ken in the way that you should do your if statement on the outside. [if "[allowedgroups]"=""] [then] [search db=^DNAforum/DNAforums.db&eqKEYdatarq=[url][dnakey][/url][!] [/!]&eqFORUMVISGdatarq=[blank][!] [/!]&GROUP1word=ww&[!] [/!]GROUP1wbrk=,&[!] [/!]leforumlvldatarq=[userlvl]&[!] [/!]FORUMLVLtype=number] [text]allowedforums=[founditems][forumid],[/founditems][/text] [/search] [/then] [else] [search db=^DNAforum/DNAforums.db&eqKEYdatarq=[url][dnakey][/url][!] [/!]&group1field=FORUMVISG&[!] [/!]&GROUP1word=ww&[!] [/!]GROUP1wbrk=,&[!] [/!]leforumlvldatarq=[userlvl]&[!] [/!]FORUMLVLtype=number] [text]allowedforums=[founditems][forumid],[/founditems][/text] [/search] [/else] [/if] Now, can you describe better what results exactly you are looking for? I think you might be running into an issue I had a while back not being able to detailed requirements but I'm not sure what results you are looking for. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search 1 Field Twice? ( Tim Robinson 2004)
  2. Re: Search 1 Field Twice? ( Jesse Proudman 2004)
  3. Re: Search 1 Field Twice? ( Donovan Brooke 2004)
  4. Re: Search 1 Field Twice? ( Kenneth Grome 2004)
  5. Re: Search 1 Field Twice? ( Jesse Proudman 2004)
  6. Re: Search 1 Field Twice? ( Jesse Proudman 2004)
  7. Re: Search 1 Field Twice? ( Kenneth Grome 2004)
  8. Re: Search 1 Field Twice? ( Tim Robinson 2004)
  9. Re: Search 1 Field Twice? ( Bob Minor 2004)
  10. Re: Search 1 Field Twice? ( Jesse Proudman 2004)
  11. Re: Search 1 Field Twice? ( Tim Robinson 2004)
  12. Re: Search 1 Field Twice? ( Kenneth Grome 2004)
  13. Re: Search 1 Field Twice? ( Jesse Proudman 2004)
  14. Re: Search 1 Field Twice? ( Kenneth Grome 2004)
  15. Search 1 Field Twice? ( Jesse Proudman 2004)
Jesse Proudman wrote: [snip] > Here's the full search: > > [text show=f]allowedforums=[search > db=^DNAforum/DNAforums.db&eqKEYdatarq=[url][dnakey][/url][if > "[allowedgroups]"=""][then]&eqFORUMVISGdatarq=[blank][/ > then][else]&group1field=FORUMVISG&wogroup1data=[allowedgroups]&group2fie > ld=FORUMVISG&eqGROUP2data=[blank][/else][/ > if]&GROUP1word=ww&GROUP1wbrk=,&leforumlvldatarq=[userlvl]&FORUMLVLtype=n > umber][founditems][forumid],[/founditems][/search][/text] Hi Jesse, I re-wrote your code so that the list could see it better and I agree with Ken in the way that you should do your if statement on the outside. [if "[allowedgroups]"=""] [then] [search db=^DNAforum/DNAforums.db&eqKEYdatarq=[url][dnakey][/url][!] [/!]&eqFORUMVISGdatarq=[blank][!] [/!]&GROUP1word=ww&[!] [/!]GROUP1wbrk=,&[!] [/!]leforumlvldatarq=[userlvl]&[!] [/!]FORUMLVLtype=number] [text]allowedforums=[founditems][forumid],[/founditems][/text] [/search] [/then] [else] [search db=^DNAforum/DNAforums.db&eqKEYdatarq=[url][dnakey][/url][!] [/!]&group1field=FORUMVISG&[!] [/!]&GROUP1word=ww&[!] [/!]GROUP1wbrk=,&[!] [/!]leforumlvldatarq=[userlvl]&[!] [/!]FORUMLVLtype=number] [text]allowedforums=[founditems][forumid],[/founditems][/text] [/search] [/else] [/if] Now, can you describe better what results exactly you are looking for? I think you might be running into an issue I had a while back not being able to detailed requirements but I'm not sure what results you are looking for. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Donovan Brooke

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:

DB Field Name? (2000) Logging purchases (1997) Using Plug-In while running 1.6.1 (1997) Additional Subtotals (1999) Bug Report, maybe (1997) Looking for a Manual (1997) Emailer error codes (1999) Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Pull Down Search (2000) expired beta (1997) Explorer oddities (1997) Re:Hideif / Showif (1998) Couple of questions (1999) WC2.0 Memory Requirements (1997) Mac v. NT (1998) Summing fields (1997) WebCommerce: Folder organization ? (1997) POP Mail Server reseting (1998) Interfacing WebMerchant to www.fedex.com (1997)