Re: Search 1 Field Twice?

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55497
interpreted = N
texte = What's an example of [allowedgroups]? I wonder if that will work if [blank] is included in it, thereby getting rid of the second item? Tim > From: Jesse Proudman > Reply-To: (WebDNA Talk) > Date: Thu, 15 Jan 2004 23:16:04 -0800 > To: (WebDNA Talk) > Subject: Re: Search 1 Field Twice? > > > On Jan 15, 2004, at 11:08 PM, Tim Robinson wrote: > >> Try them both without the rq and see what happens. As Ken says, you >> will >> definitely get zero results if the same field MUST contain data, and >> MUST be >> blank.... > > Ok, I made them both not required and it's pulling up records where > that field isn't blank and doesn't contain the other piece of data... > Ideas? > > Basically I need a search that looks for all records where this field > contains "ABC" or is blank.... > > Thanks > > -- > Jesse Williams-Proudman > Blue Box Development :: Custom Web Solutions > +1.206.778.8777 :: jesse@blueboxdev.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://webdna.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://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)
What's an example of [allowedgroups]? I wonder if that will work if [blank] is included in it, thereby getting rid of the second item? Tim > From: Jesse Proudman > Reply-To: (WebDNA Talk) > Date: Thu, 15 Jan 2004 23:16:04 -0800 > To: (WebDNA Talk) > Subject: Re: Search 1 Field Twice? > > > On Jan 15, 2004, at 11:08 PM, Tim Robinson wrote: > >> Try them both without the rq and see what happens. As Ken says, you >> will >> definitely get zero results if the same field MUST contain data, and >> MUST be >> blank.... > > Ok, I made them both not required and it's pulling up records where > that field isn't blank and doesn't contain the other piece of data... > Ideas? > > Basically I need a search that looks for all records where this field > contains "ABC" or is blank.... > > Thanks > > -- > Jesse Williams-Proudman > Blue Box Development :: Custom Web Solutions > +1.206.778.8777 :: jesse@blueboxdev.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://webdna.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://webdna.smithmicro.com/ Tim Robinson

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:

[SHOWIF AND/OR] (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) show all problem (1997) no [search] with NT (1997) Sorting by highest number of matches unique to a field (2003) database visibility (2000) WebMerchant 3.0? (1998) WebCat chatroom/hyperboard (1997) WYSIWYG Entry of text fields (2001) Order not created error (1997) My URL, Your URL (2002) creator code (1997) Configuring E-mail (1997) [authenticate] (1999) Limit to Field Length in DB (1998) Wow .. (2003) Windows XP + Apache 2.0 + WebDNA (2002) Tab Charactor (1997) lazy programming (2000)