Re: Strange Search Results

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56049
interpreted = N
texte = Hi Justin, It seems to me that when searching on your test, text characters are being ignored. I tried searching on 731hjkahjk987 and it returned the record with 731987. Erol ----- Original Message ----- From: "Justin Carroll" To: "WebDNA Talk" Sent: Wednesday, February 11, 2004 6:04 PM Subject: Re: Strange Search Results > This is a link to my test: > http://secure.sanduskyregister.com/justin/test/ > > Why, when you type in "aslfkjsdlfj" or anything BESIDES a number, does it return sku 1 and 3 but not 2? Thanks. > > Justin Carroll > > On Thursday, April 1, 1943, WebDna @ Inkblot Media wrote: > >Hi Justin, > > > >Your search seems to be: > > > >[search > >db=database.db&eqend_datedata=[url][txtKeyword][/url]&end_datetype=num&end_ d > >atesdir=de] > > > >It does not return all record in my DB. > > > >See here: > >http://www.inkblotmedia.com/justin/ > > > >Ron > > > > > >----- Original Message ----- > >From: "Justin Carroll" > >To: "WebDNA Talk" > >Sent: Wednesday, February 11, 2004 9:02 AM > >Subject: Re: Strange Search Results > > > > > >I've tried everything suggested. Nothing seems to work. It's such a simple > >search string to return such a problem. I'm open to any other suggestions. > >Thank you. > > > >Justin Carroll > > > >On Thursday, April 1, 1943, Kenneth Grome wrote: > >>>This is my search string: > >>>[search > >>>db=database.db&end_datedata=[url][txtKeyword][/url]&end_datetype=num&end_ d > >atesdir=de] > >>> > >>>In my database, end_date holds numerical date values (ex. 735748). > >>> > >>>When I search for "735748" it will pull just that record. This is > >>>fine. But can someone explain to me why when I search for any text > >>>(ex. alsdlajsdf) that this search returns all the records in my > >>>database instead of nothing? Thanks. > >> > >> > >>Because you're supposed to put a comparison operator in front of > >>"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or > >>"wa" or some other comparison operator in front, then see what kind > >>of results you get ... :) > >>-- > >> > >>Kenneth Grome > >>WebDNA Programmer > >>Outsource Service Provider > >>Phone: +6332 255-6591 > >> > >>------------------------------------------------------------- > >>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/ > > > > > >------------------------------------------------------------- > >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/ > > ------------------------------------------------------------- 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: Strange Search Results ( Justin Carroll 2004)
  2. Re: Strange Search Results ( "Erol Guneri" 2004)
  3. Re: Strange Search Results ( Justin Carroll 2004)
  4. Re: Strange Search Results ( Glenn Busbin 2004)
  5. Re: Strange Search Results ( Justin Carroll 2004)
  6. Re: Strange Search Results ( Glenn Busbin 2004)
  7. Re: Strange Search Results ( John Peacock 2004)
  8. Re: Strange Search Results ( Justin Carroll 2004)
  9. Re: Strange Search Results ( Justin Carroll 2004)
  10. Re: Strange Search Results ( "WebDna @ Inkblot Media" 2004)
  11. Re: Strange Search Results ( Justin Carroll 2004)
  12. Re: Strange Search Results ( "WebDna @ Inkblot Media" 2004)
  13. Re: Strange Search Results ( John Peacock 2004)
  14. Re: Strange Search Results ( Justin Carroll 2004)
  15. Re: Strange Search Results ( "Gary Krockover" 2004)
  16. Re: Strange Search Results ( Justin Carroll 2004)
  17. Re: Strange Search Results ( Justin Carroll 2004)
  18. Re: Strange Search Results ( Kenneth Grome 2004)
  19. Re: Strange Search Results ( "Matthew C. Bohne" 2004)
  20. Re: Strange Search Results ( Justin Carroll 2004)
  21. Strange Search Results ( Justin Carroll 2004)
Hi Justin, It seems to me that when searching on your test, text characters are being ignored. I tried searching on 731hjkahjk987 and it returned the record with 731987. Erol ----- Original Message ----- From: "Justin Carroll" To: "WebDNA Talk" Sent: Wednesday, February 11, 2004 6:04 PM Subject: Re: Strange Search Results > This is a link to my test: > http://secure.sanduskyregister.com/justin/test/ > > Why, when you type in "aslfkjsdlfj" or anything BESIDES a number, does it return sku 1 and 3 but not 2? Thanks. > > Justin Carroll > > On Thursday, April 1, 1943, WebDna @ Inkblot Media wrote: > >Hi Justin, > > > >Your search seems to be: > > > >[search > >db=database.db&eqend_datedata=[url][txtKeyword][/url]&end_datetype=num&end_ d > >atesdir=de] > > > >It does not return all record in my DB. > > > >See here: > >http://www.inkblotmedia.com/justin/ > > > >Ron > > > > > >----- Original Message ----- > >From: "Justin Carroll" > >To: "WebDNA Talk" > >Sent: Wednesday, February 11, 2004 9:02 AM > >Subject: Re: Strange Search Results > > > > > >I've tried everything suggested. Nothing seems to work. It's such a simple > >search string to return such a problem. I'm open to any other suggestions. > >Thank you. > > > >Justin Carroll > > > >On Thursday, April 1, 1943, Kenneth Grome wrote: > >>>This is my search string: > >>>[search > >>>db=database.db&end_datedata=[url][txtKeyword][/url]&end_datetype=num&end_ d > >atesdir=de] > >>> > >>>In my database, end_date holds numerical date values (ex. 735748). > >>> > >>>When I search for "735748" it will pull just that record. This is > >>>fine. But can someone explain to me why when I search for any text > >>>(ex. alsdlajsdf) that this search returns all the records in my > >>>database instead of nothing? Thanks. > >> > >> > >>Because you're supposed to put a comparison operator in front of > >>"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or > >>"wa" or some other comparison operator in front, then see what kind > >>of results you get ... :) > >>-- > >> > >>Kenneth Grome > >>WebDNA Programmer > >>Outsource Service Provider > >>Phone: +6332 255-6591 > >> > >>------------------------------------------------------------- > >>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/ > > > > > >------------------------------------------------------------- > >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/ > > ------------------------------------------------------------- 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/ "Erol Guneri"

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:

[OT] On a side note.. (2003) Multiple 'Users.db' files not possible (1997) [WebDNA] [MATH] strangeness (2013) convert characters (2003) grouped fields? (1999) my price won't move (1997) re: Large databases in WebCat (1997) PSC recommends what date format yr 2000??? (1997) [cart] number range ?? (2001) WebCat2b12--[searchstring] bug (1997) type 2 errors with ssl server (1997) Two prices in shoppingcart? (1997) WebCatalog for guestbook ? (1997) Separate SSL Server (1997) [delete] problem (1997) WebCatalog for Postcards ? (1997) Strange intermittent WebDNA problems (2008) TCPConnect (2005) WCS Newbie question (1997) WC 2.0 frames feature (1997)