Re: Strange Search Results

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56023
interpreted = N
texte = I know, I posted back with a correction; however, the problem is still = coming up. It's very strange. 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 know, I posted back with a correction; however, the problem is still = coming up. It's very strange. 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:

Problems appending to database (1997) Weird error/limit - something amiss? (1997) Multiple catalog databases and showcart (1997) Date Calulation (1997) Problem with shownext (2003) Mystery authentication (1997) Stopping bad HTML propagation ? (1997) [WebDNA] Talklist Archive & Twitter (2009) Logging purchases (1997) comma-delimited email (1998) HELLO (2000) Guest Book (2002) Return records from another (1997) Help name our technology! I found it (1997) World Address Info (2003) Server crashes and triggers . . . are they linked? (2001) pop up menu's (1998) text size limitation (1997) Quickie question on the email templates (1997) Re[2]: Major problem (1999)