Re: Why is this search finding the right thing?!
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42950
interpreted = N
texte = Hey.... I get it![SEARCH DB=data/registration.db&GROUP1field=RENEWAL_DATE&neGROUP1datarq=[blank]&GROU P2field=RENEWAL_DATE &leGROUP2datarq=[math]{[DATE]}+{00/02/0000}[/math]]Woohoo!-- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Tim Robinson
> Reply-To: (WebCatalog Talk) > Date: Wed, 28 Aug 2002 16:24:33 > To: (WebCatalog Talk) > Subject: Re: Why is this search finding the right thing?! > > Yes, that makes sense. I'm sure you can only test the same field once. Could > anyone possibly give me a hand turning this into a group search. I've never > used groups, and all the examples seem to deal with text, and seem more > simple. > > &neRENEWAL_DATEdatarq=[blank]&leRENEWAL_DATEdatarq=[math]{[DATE]}+{00/02/000 > 0}[/math] > > Thanks in advance. > Tim > -- > Tim Robinson > IDFK Web Developments > tim@idfk.com.au > 114a/40 Yeo Street > Neutral Bay 2089 > Australia > Phone +612 9908 2134 > Fax +612 9908 4837 > >> From: Inkblot Media >> Reply-To: (WebCatalog Talk) >> Date: Tue, 27 Aug 2002 23:00:16 >> To: (WebCatalog Talk) >> Subject: Re: Why is this search finding the right thing?! >> >> This taken from a current email sent in by Brian Fries: >> -------------------------------------------------------------------- >> >> The [search] context only supports one selection parameter for each >> DB field. You cannot test the same field directly twice in the same >> search. >> >> However, you can get around this limitation by using group fields and >> only specifying one field for the group. >> >> Using your example, you could do the following: >> >> &wnlocationdata=HE&group1field=location&wogroup1datarq=_open >> >> >> Since location and group1 are different identifiers, both >> selection parameters will be executed. >> >> --------------------------------------------------------------------- >> >> This seems to fit. >> >> Let me know if you need help with this. >> >> ------------------------------------------------------------ >> Ronald Kirkland - President >> Inkblot Media - Internet Solutions Experts >> Phone: 949.400.4456 * FAX: 949.654.0269 >> Visit: http://www.inkblotmedia.com >> Email: ron@inkblotmedia.com >> ------------------------------------------------------------ >> >> >> ----- Original Message ----- >> From: Tim Robinson >> To: WebCatalog Talk >> Sent: Tuesday, August 27, 2002 9:40 PM >> Subject: Why is this search finding the right thing?! >> >> >>> Hi there, >>> >>> I have what seems to be a very simple search, but it's not finding the >> right >>> data. In the search below, the field RENEWAL_DATE has been saved in the >>> [math]{[DATE]}[/math] format. >>> >>> [search >>> >> db=data/registration.db&neRENEWAL_DATEdatarq=[blank]&leRENEWAL_DATEdatarq=[m >>> ath]{[DATE]}[/math]] >>> >>> this brings the following [founditems] >>> [SKU] - [RENEWAL_DATE] - [math]{[DATE]}[/math]: >>> >>> 323901715812587 - 732211 - 731455 >>> 323902448613912 - 731814 - 731455 >>> 32389306275769 - 731480 - 731455 >>> 32389304335747 - 731481 - 731455 >>> 32389306505781 - 731479 - 731455 >>> 323902470913955 - 731814 - 731455 >>> >>> It shouldn't find ANY of these... it seems to only be finding the >>> neRENEWAL_DATEdatarq=[blank] items and taking no notice of the other half >> of >>> the search... leRENEWAL_DATEdatarq=[math]{[DATE]}[/math] >>> >>> Any ideas anyone? >>> >>> Thanks in advance. >>> Tim >>> >>> -- >>> Tim Robinson >>> IDFK Web Developments >>> tim@idfk.com.au >>> 114a/40 Yeo Street >>> Neutral Bay 2089 >>> Australia >>> Phone +612 9908 2134 >>> Fax +612 9908 4837 >>> >>> >>> >>> ------------------------------------------------------------- >>> 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://search.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://search.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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hey.... I get it![SEARCH DB=data/registration.db&GROUP1field=RENEWAL_DATE&neGROUP1datarq=[blank]&GROU P2field=RENEWAL_DATE &leGROUP2datarq=[math]{[date]}+{00/02/0000}[/math]]Woohoo!-- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Tim Robinson > Reply-To: (WebCatalog Talk) > Date: Wed, 28 Aug 2002 16:24:33 > To: (WebCatalog Talk) > Subject: Re: Why is this search finding the right thing?! > > Yes, that makes sense. I'm sure you can only test the same field once. Could > anyone possibly give me a hand turning this into a group search. I've never > used groups, and all the examples seem to deal with text, and seem more > simple. > > &neRENEWAL_DATEdatarq=[blank]&leRENEWAL_DATEdatarq=[math]{[date]}+{00/02/000 > 0}[/math] > > Thanks in advance. > Tim > -- > Tim Robinson > IDFK Web Developments > tim@idfk.com.au > 114a/40 Yeo Street > Neutral Bay 2089 > Australia > Phone +612 9908 2134 > Fax +612 9908 4837 > >> From: Inkblot Media >> Reply-To: (WebCatalog Talk) >> Date: Tue, 27 Aug 2002 23:00:16 >> To: (WebCatalog Talk) >> Subject: Re: Why is this search finding the right thing?! >> >> This taken from a current email sent in by Brian Fries: >> -------------------------------------------------------------------- >> >> The [search] context only supports one selection parameter for each >> DB field. You cannot test the same field directly twice in the same >> search. >> >> However, you can get around this limitation by using group fields and >> only specifying one field for the group. >> >> Using your example, you could do the following: >> >> &wnlocationdata=HE&group1field=location&wogroup1datarq=_open >> >> >> Since location and group1 are different identifiers, both >> selection parameters will be executed. >> >> --------------------------------------------------------------------- >> >> This seems to fit. >> >> Let me know if you need help with this. >> >> ------------------------------------------------------------ >> Ronald Kirkland - President >> Inkblot Media - Internet Solutions Experts >> Phone: 949.400.4456 * FAX: 949.654.0269 >> Visit: http://www.inkblotmedia.com >> Email: ron@inkblotmedia.com >> ------------------------------------------------------------ >> >> >> ----- Original Message ----- >> From: Tim Robinson >> To: WebCatalog Talk >> Sent: Tuesday, August 27, 2002 9:40 PM >> Subject: Why is this search finding the right thing?! >> >> >>> Hi there, >>> >>> I have what seems to be a very simple search, but it's not finding the >> right >>> data. In the search below, the field RENEWAL_DATE has been saved in the >>> [math]{[date]}[/math] format. >>> >>> [search >>> >> db=data/registration.db&neRENEWAL_DATEdatarq=[blank]&leRENEWAL_DATEdatarq=[m >>> ath]{[date]}[/math]] >>> >>> this brings the following [founditems] >>> [SKU] - [RENEWAL_DATE] - [math]{[date]}[/math]: >>> >>> 323901715812587 - 732211 - 731455 >>> 323902448613912 - 731814 - 731455 >>> 32389306275769 - 731480 - 731455 >>> 32389304335747 - 731481 - 731455 >>> 32389306505781 - 731479 - 731455 >>> 323902470913955 - 731814 - 731455 >>> >>> It shouldn't find ANY of these... it seems to only be finding the >>> neRENEWAL_DATEdatarq=[blank] items and taking no notice of the other half >> of >>> the search... leRENEWAL_DATEdatarq=[math]{[date]}[/math] >>> >>> Any ideas anyone? >>> >>> Thanks in advance. >>> Tim >>> >>> -- >>> Tim Robinson >>> IDFK Web Developments >>> tim@idfk.com.au >>> 114a/40 Yeo Street >>> Neutral Bay 2089 >>> Australia >>> Phone +612 9908 2134 >>> Fax +612 9908 4837 >>> >>> >>> >>> ------------------------------------------------------------- >>> 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://search.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://search.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://search.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://search.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:
Search in 2 or more catalogs (1997)
Link in a text (2000)
Email (1998)
Search in 2 or more catalogs (1997)
Re[2]: Next X hits (1996)
MOOOOOO (2000)
Emailer port change (1997)
RE: WebCat and image maps (1997)
Changing to a windows mounted share from a Mac OS X machine (2002)
Webmerchant quitting (1998)
Separate SSL Server (1997)
WebCat2b13 Command Reference Doc error (1997)
How to redirect based on price subtotal? (1998)
LOG IN LOG OUT (1997)
WebCat2final1 crashes (1997)
Expert tech support ... (2000)
Smart caching problems with 2.1b3? (1997)
Looking up two prices in database? (1997)
Confirming a bug/oddity (2003)
NEW INFO: I'm stuck: Can't open order file. Ignoring[OrderFile] context (2000)