Re: why won't this work, please tell me???

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37414
interpreted = N
texte = i'm use to sql and you can search the same field as many times as you like.field > 2 and field < 6 and field like '%0%' and field not in (select * from etc)are you saying that there are not any circumstances where you can do this in webcat without using a nested search???on 26/7/01 2:54 PM, Sam Lewis at sam@samlewis.com wrote:>> okay so it had nothing to do with reserved words, it still won't work. >> >> Why is it so hard to do something so simple all i want to do is get >> everything from the database from between two dates. >> >> < 2002 and > 2000 how hard could it be. > > You're trying to search the same field twice. Use the range > comparison instead of both ge and le > > rnThe_Datedatarq=2000 2002 should do it. > ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: why won't this work, please tell me??? (Anup Setty 2001)
  2. Re: why won't this work, please tell me??? (Kenneth Grome 2001)
  3. Re: why won't this work, please tell me??? (Sam Lewis 2001)
  4. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  5. Re: why won't this work, please tell me??? (Sam Lewis 2001)
  6. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  7. Re: why won't this work, please tell me??? (Gary J. Krockover 2001)
  8. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  9. Re: why won't this work, please tell me??? (Andrew Simpson 2001)
  10. Re: why won't this work, please tell me??? (Brian Boegershausen 2001)
  11. why won't this work, please tell me??? (Andrew Simpson 2001)
i'm use to sql and you can search the same field as many times as you like.field > 2 and field < 6 and field like '%0%' and field not in (select * from etc)are you saying that there are not any circumstances where you can do this in webcat without using a nested search???on 26/7/01 2:54 PM, Sam Lewis at sam@samlewis.com wrote:>> okay so it had nothing to do with reserved words, it still won't work. >> >> Why is it so hard to do something so simple all i want to do is get >> everything from the database from between two dates. >> >> < 2002 and > 2000 how hard could it be. > > You're trying to search the same field twice. Use the range > comparison instead of both ge and le > > rnThe_Datedatarq=2000 2002 should do it. > ------------------------------------------------------------- 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://search.smithmicro.com/ Andrew Simpson

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:

shipcost (1997) Different Tax levels (1998) Major Security Hole IIS NT (1998) Showif Or (2000) WebMerchant 3.0 for Mac shipping now (1998) about this server and links to who (1997) All questions are welcome on this list (1997) Guestbook (2000) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) form data submission gets truncated (1997) no serial? (1998) US Postal Service API (2007) DataBaseHelper Flawed (1997) Is the list server working? (1998) Questions To Answer (1997) Date problems (1997) [WebDNA] Content-Type (2010) show all problem (1997) PCS Frames-Default page is solution! (1997) For Grant: Webcatalog 4.0 - When will we be able to betatest it? (2000)