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=numYou'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 SoftwareWebsite 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:
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=numYou'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 SoftwareWebsite 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)