Re: multiple search of same field

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24159
interpreted = N
texte = You can't search the same field in two ways unless you use the GROUP field concept. iewoKEYWORDSdatarq=&GROUP1field=keywords&waGROUP1datarq=John.>ok back to this again > >i have tried : > >[search >db=data/images.db&wokeywordsdata=[keywordsdata1]&[descriptioncomp]keywordsda >ta=[keywordsdata2]&max=[max]&keywordswbrk=,.&keywordsword=ww] > >[descriptioncomp] as passed from a popup list of wa,wo or ne >If keywordsdata2 is blank it works but if i enter a value it wont work. > >I have tried the same search using 2 DIFFERENT fields and it works >but not on the same field. > >Any help > >thanks > >Seanie > >> elive talklists wrote: >> >>> Hi all >>> >>> I have a current search on stockbyte.com that allows me >>> search for keywords in one field using AND or OR >>> eg, dog and cat >>> or dog or cat >>> >>> I can also make this do 'neither dog nor cat' >>> >>> but what i Want is 'and dog not cat' >> >> isn't it such that you simply add rq to any arguments (if that is the >> right term) that >> you want to ReQuire? >> Like so- >> &eqFIELD1NAMEdatarq=dog&neFIELD1NAMEdatarq=cat&... >> Off the top of my head, hopefully I have it right. >> >>> >>> I have tried groupfields etc and have just fried my brain trying to >>> get it working...any help out there >>> >>> also...what involved in doing a search within a search >>> eg : search for 'dog and cat' and then search the results for 'black' >>> is this just a second full search for 'dog,cat and black'? >> >> you could put the search for black within the founditems loop of the search >> for dog and >> cat, >> but why not just add that argument ReQuiring black in the field that must >> have a value of >> black? >> >> -John >> >> >> ------------------------------------------------------------- >> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >> To end your Mail problems go to . >> >> 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 >> > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 --------------------------------- John A. Hill Smith Micro Software Internet Solutions Division eCommerce / Consulting / Hosting http://www.smithmicro.com (formerly Pacific Coast Software)------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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: multiple search of same field (John Hill 1999)
  2. Re: multiple search of same field (elive talklists 1999)
You can't search the same field in two ways unless you use the GROUP field concept. iewoKEYWORDSdatarq=&GROUP1field=keywords&waGROUP1datarq=John.>ok back to this again > >i have tried : > >[search >db=data/images.db&wokeywordsdata=[keywordsdata1]&[descriptioncomp]keywordsda >ta=[keywordsdata2]&max=[max]&keywordswbrk=,.&keywordsword=ww] > >[descriptioncomp] as passed from a popup list of wa,wo or ne >If keywordsdata2 is blank it works but if i enter a value it wont work. > >I have tried the same search using 2 DIFFERENT fields and it works >but not on the same field. > >Any help > >thanks > >Seanie > >> elive talklists wrote: >> >>> Hi all >>> >>> I have a current search on stockbyte.com that allows me >>> search for keywords in one field using AND or OR >>> eg, dog and cat >>> or dog or cat >>> >>> I can also make this do 'neither dog nor cat' >>> >>> but what i Want is 'and dog not cat' >> >> isn't it such that you simply add rq to any arguments (if that is the >> right term) that >> you want to ReQuire? >> Like so- >> &eqFIELD1NAMEdatarq=dog&neFIELD1NAMEdatarq=cat&... >> Off the top of my head, hopefully I have it right. >> >>> >>> I have tried groupfields etc and have just fried my brain trying to >>> get it working...any help out there >>> >>> also...what involved in doing a search within a search >>> eg : search for 'dog and cat' and then search the results for 'black' >>> is this just a second full search for 'dog,cat and black'? >> >> you could put the search for black within the founditems loop of the search >> for dog and >> cat, >> but why not just add that argument ReQuiring black in the field that must >> have a value of >> black? >> >> -John >> >> >> ------------------------------------------------------------- >> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >> To end your Mail problems go to . >> >> 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 >> > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 --------------------------------- John A. Hill Smith Micro Software Internet Solutions Division eCommerce / Consulting / Hosting http://www.smithmicro.com (formerly Pacific Coast Software)------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 John Hill

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:

email address with spaces (2001) whole word matching (2004) Database Fields (1997) WebCatalog can't find database (1997) NT Woes (1997) feature request 4.5 or 5 (2001) Re:Using WebMerchant Only? (1998) Updating Prices in Online Database (1999) New Server? (2006) Major bug report on rootbeer (1997) more ! testing (1997) Can't use old cart file (was One more try) (1997) urls (2005) redirect problem - bug? (2003) wierd [cart] action! (1997) Applescript, WebDNA, and PDF (1997) How to set up searching - properly (2000) Buying sans cart (1997) how to kill webcat ? (2002) [WriteFile] problems (1997)