Re: Strange Search Results

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56038
interpreted = N
texte = 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/ 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, 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/ "WebDna @ Inkblot Media"

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:

NT 4.0/IIS WebCat Installation (1998) [WebDNA] Random Numbers no repeat within a range (2014) Max Record length restated as maybe bug (1997) SSL and reg web* (1997) Payflow Pro on OSX (2003) Crashes and prior posting (2006) free "Image Viewer" widget (2004) Testing (2002) [WriteFile] problems (1997) [WebDNA] why is this cookie being set to expire at end of browser session? (2009) Verifying both name and password (was: New Problem) (1997) Decrypting a user password (2000) Incompatibility with WebCat 3 templates ... (2000) quick setheader questions... (2000) form data submission gets truncated (1997) (1997) unsubscribe (1997) Serving images from databases (1998) [WebDNA] Encode cookies ONLY via "method=Base64" (2008) INDEXING blank field (2001)