Re: Search: Is this possible?

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 63079
interpreted = N
texte = There's no type specifiers I noticed. Also, with all of the search terms required, I wouldn't expect this to work. Perhaps this is a better approach: db=joel_calendarevents.db& leBEGINDATEdatarq=[math]{[m]/[index]/[y]}[/math]&BEGINDATEtype=date& geENDDATEdatarq=[math]{[m]/[index]/[y]}[/math]&ENDDATEtype=date& rnCALdatarq=0,1&CALtype=num& BEGINTIMEsort=1&BEGINTIMEtype=num You've stumbled across an area in searching that can be difficult ORing when a valid result is required. >[search >db=joel_calendarevents.db&leBEGINDATEdatarq=[math]{[m]/[index]/[y]}[/math]&g >eENDDATEdatarq=[math]{[m]/[index]/[y]}[/math]&eqCALdatarq=0&eqGROUP1datarq=1 >&GROUP1field=CAL&BEGINTIMEsort=1&BEGINTIMEtype=num] > > >On 9/21/05 2:56 PM, "John Hill" wrote: > >> What's your entire search string? >> >>> That returned a record whose CAL field contained 20401. >>> >>> >>> On 9/21/05 2:42 PM, "John Hill" wrote: >>> >>>> Use a second group field. eqCALdata=0 eqGROUP1data=1 GROUP1field=CAL >>>> >>>>> I have an events database with a field called "CAL". I want to find all >>>>> records where the CAL field is equal to either 0 or 1. If this field >>>>> contains some other number with a 0 or 1 (like 20401), I don't want the >>>>> data >>>>> returned. I've tried a few combinations of eqCALdata, woCALdata, and >>>>> wsCALdata with no luck. I'd prefer to perform a single search for this. >>>>> >>>>> Is this possible? > > > > >------------------------------------------------------------- >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/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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: Is this possible? ( Clint Davis 2005)
  2. Re: Search: Is this possible? ( Stuart Tremain 2005)
  3. Re: Search: Is this possible? ( Frank Nordberg 2005)
  4. Re: Search: Is this possible? ( Brian Fries 2005)
  5. Re: Search: Is this possible? ( Gary Krockover 2005)
  6. Re: Search: Is this possible? ( Clint Davis 2005)
  7. Re: Search: Is this possible? ( Clint Davis 2005)
  8. Re: Search: Is this possible? ( Gary Krockover 2005)
  9. Re: Search: Is this possible? ( John Hill 2005)
  10. Re: Search: Is this possible? ( Clint Davis 2005)
  11. Re: Search: Is this possible? ( John Hill 2005)
  12. Re: Search: Is this possible? ( Clint Davis 2005)
  13. Re: Search: Is this possible? ( John Hill 2005)
  14. Search: Is this possible? ( Clint Davis 2005)
There's no type specifiers I noticed. Also, with all of the search terms required, I wouldn't expect this to work. Perhaps this is a better approach: db=joel_calendarevents.db& leBEGINDATEdatarq=[math]{[m]/[index]/[y]}[/math]&BEGINDATEtype=date& geENDDATEdatarq=[math]{[m]/[index]/[y]}[/math]&ENDDATEtype=date& rnCALdatarq=0,1&CALtype=num& BEGINTIMEsort=1&BEGINTIMEtype=num You've stumbled across an area in searching that can be difficult ORing when a valid result is required. >[search >db=joel_calendarevents.db&leBEGINDATEdatarq=[math]{[m]/[index]/[y]}[/math]&g >eENDDATEdatarq=[math]{[m]/[index]/[y]}[/math]&eqCALdatarq=0&eqGROUP1datarq=1 >&GROUP1field=CAL&BEGINTIMEsort=1&BEGINTIMEtype=num] > > >On 9/21/05 2:56 PM, "John Hill" wrote: > >> What's your entire search string? >> >>> That returned a record whose CAL field contained 20401. >>> >>> >>> On 9/21/05 2:42 PM, "John Hill" wrote: >>> >>>> Use a second group field. eqCALdata=0 eqGROUP1data=1 GROUP1field=CAL >>>> >>>>> I have an events database with a field called "CAL". I want to find all >>>>> records where the CAL field is equal to either 0 or 1. If this field >>>>> contains some other number with a 0 or 1 (like 20401), I don't want the >>>>> data >>>>> returned. I've tried a few combinations of eqCALdata, woCALdata, and >>>>> wsCALdata with no luck. I'd prefer to perform a single search for this. >>>>> >>>>> Is this possible? > > > > >------------------------------------------------------------- >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/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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/ 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:

WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) More questions about serial number dishing (1997) Document Contains No Data! (1997) [WebDNA] sendmail html with image attachments (2008) Emails are Stuck (2003) RE: Can a database get stomped by simultaneous access? (1997) b12 cannot limit records returned and more. (1997) Where's Cart Created ? (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Some Advise needed (1997) Properly implemented switch-case would be nice ... (2002) Bugs? What Bugs? was:Spawning Holdup? (2000) shownext problems & formvariables (1998) mySQL --- problem?? (2004) Listserver problem (1997) ShowNext (1997) emailer (1997) Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000) WebDNA-Talk Digests (1997) Credit card types (1997)