Re: Strange Search Results

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56050
interpreted = N
texte = Thanks. On Friday, April 2, 1943, Erol Guneri wrote: >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=3Ddatabase.db&eqend_datedata=3D[url][txtKeyword][/url]&end_= datetype=3Dnum&end_ >d >> >atesdir=3Dde] >> > >> >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=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_= datetype=3Dnum&end_ >d >> >atesdir=3Dde] >> >>> >> >>>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/ > ------------------------------------------------------------- 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)
Thanks. On Friday, April 2, 1943, Erol Guneri wrote: >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=3Ddatabase.db&eqend_datedata=3D[url][txtKeyword][/url]&end_= datetype=3Dnum&end_ >d >> >atesdir=3Dde] >> > >> >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=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_= datetype=3Dnum&end_ >d >> >atesdir=3Dde] >> >>> >> >>>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/ > ------------------------------------------------------------- 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/ Justin Carroll

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:

Re:no [search] with NT (1997) database size? (1997) Math with Time (1997) Tip O' the Week (1996) WebCatalog Hosting (1996) LookUp Tag (1997) Setting up WebCatalog with Retail Pro data (1996) [WebDNA] fastcgi 7+ & [cart]? (2010) Erotic Sites (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Email (1998) Multiple fields on 1 input (1997) customizing the color of user's pages (1997) Template Cache problem, bombing WebSTAR problem (2000) Mail Integration (1999) Dummy Form Variables Needed (2000) Re:2nd WebCatalog2 Feature Request (1996) WebCatalog2 Feature Feedback (1996) encrypted query string trouble on OSX (2001) Sku numbers (1997)