Re: Strange Search Results

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56022
interpreted = N
texte = >This is my search string: >[search >db=database.db&end_datedata=[url][txtKeyword][/url]&end_datetype=num&end_datesdir=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/ 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)
>This is my search string: >[search >db=database.db&end_datedata=[url][txtKeyword][/url]&end_datetype=num&end_datesdir=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/ Kenneth Grome

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:

Opinion: [input] should be called [output] ... (1997) X etc.... (1999) Associative lookup style? + bit more (1997) [date] insanity! (2001) Reports of ErrorLog.txt not being written in Linux (2000) problems with 2 tags (1997) mass mailing (1998) Count regular expressions in a file (2007) Errata: WCS Newbie question (1997) Mac: [ListFiles] bug alert (1997) multi-paragraph fields (1997) Webcatalog quitting (1997) Help name our technology! (1997) Thanks Grant (1997) [append] and SSL (1997) WebCat for Unix?? (1997) Search technique question (1998) Multiple catalog databases and showcart (1997) Error Template (1999) WebCat2b12--[searchstring] bug (1997)