Re: Why is this search finding the right thing?!
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42949
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Problem 2 of 2 (was: Shipping Confusion) (2000)
Include (2000)
Card clearance, problems - solutions? (1997)
Mult-File Upload w/ Web Star (2000)
Nested tags count question (1997)
b12 cannot limit records returned and more. (1997)
Referrer problem - Truncation (1998)
problems with 2 tags shakur (1997)
Running _every_ page through WebCat ? (1997)
PCS Frames (1997)
SiteGaurd file Cache vs webcatalog cache (1997)
Locking up with WebCatalog... (1997)
Protect vs Authenicate (1997)
search context w shownext works! (1997)
emailer on Windows Beta 18 (1997)
Problems getting parameters passed into email. (1997)
Mac Vs WindowsNT (1997)
PSC recommends what date format yr 2000??? (1997)
no global [username] or [password] displayed ... (1997)
Looking up two prices in database? (1997)