Re: Strange Search Results

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56033
interpreted = N
texte = 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=20 >>db=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_= datetype=3Dnum&end_datesdir=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=20 >>fine. But can someone explain to me why when I search for any text=20 >>(ex. alsdlajsdf) that this search returns all the records in my=20 >>database instead of nothing? Thanks. > > >Because you're supposed to put a comparison operator in front of=20 >"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or=20 >"wa" or some other comparison operator in front, then see what kind=20 >of results you get ... :) >--=20 > >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/ 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)
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=20 >>db=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_= datetype=3Dnum&end_datesdir=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=20 >>fine. But can someone explain to me why when I search for any text=20 >>(ex. alsdlajsdf) that this search returns all the records in my=20 >>database instead of nothing? Thanks. > > >Because you're supposed to put a comparison operator in front of=20 >"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or=20 >"wa" or some other comparison operator in front, then see what kind=20 >of results you get ... :) >--=20 > >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/ 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:

Running 2 two WebCatalog.acgi's (1996) IPADDRESS mystery (2003) Check boxes (1997) Nested vs conditional (1997) default value from Lookup (was Grant, please help me) (1997) WCS Newbie question (1997) Disappearing data [OT] (2002) letterrip and webcats emailer (1998) A quickie question (1997) WebCat for mass emailings (1997) [WebDNA] [announce] CICADA Gold Products (2009) Clear/Reset form with JavaScript (2001) WebCatalog stalls (1998) Integration with SQL (1997) Dual 2GHz G5 (2003) Need relative path explanation (1997) removing commas from a preformatted number (2000) Include a big block of text (1997) Another question (1997) [ShowIf] a either fields are blank (1998)