What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Odd search results, or odd programmer, not sure which...

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42865
interpreted = N
texte = Hey all,database has a field, named location. In that field, some examples: HE170 HE170_open FBC170 FBC170_open TOP1170 TOP1170_open DMR171 DMR171_openetc...Now, I need a search that will show only those records that contain the _open and do *not* contain HE. I can do one or the other, but not both. In fact, trying both produces some strange results:....&wnlocationdata=HE&wolocationdatarq=_open will hide the records with HE, but will also hide the records with _open (shouldn't wo show those, not hide them?).....&wolocationdatarq=_open&wnlocationdata=HE will show everything, _open, non-_open, HE and other records.....&wolocationdatarq=_open&wnlocationdata=HE&allreq=T will show all HE records, and all _open records. It will hide the non-_open records for all but the HE's. (if that's clear...)....&wolocationdatarq=_open&nelocationdatarq=HE shows the exact same as above.....&wolocationdatarq=_open&nelocationdata=HE shows the same as above, and interestingly, ignores my sort order and places all the HE170_open to the top, then the rest.Any combinations that I'm missing? I have flushed db's between tries as well. No funky characters in the db either. Any other ideas?I'm assuming that the numbers in the words are giving it the fits. Do I recall a ww search, wordswith perhaps? I don't see it in the docs but will try it now.GK Gary Krockover Webmaster Internet Gateway www.thegateway.net (512) 930-1022 ------------------------------------------------------------- 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: Odd search results, or odd programmer, not sure which... (Kenneth Grome 2002)
  2. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  3. Re: Odd search results, or odd programmer, not sure which... (Brian Fries 2002)
  4. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  5. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  6. Re: Odd search results, or odd programmer, not sure which... (Inkblot Media 2002)
  7. Re: Odd search results, or odd programmer, not sure which... (Inkblot Media 2002)
  8. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  9. Re: Odd search results, or odd programmer, not sure which... (Glenn Busbin 2002)
  10. Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
Hey all,database has a field, named location. In that field, some examples: HE170 HE170_open FBC170 FBC170_open TOP1170 TOP1170_open DMR171 DMR171_openetc...Now, I need a search that will show only those records that contain the _open and do *not* contain HE. I can do one or the other, but not both. In fact, trying both produces some strange results:....&wnlocationdata=HE&wolocationdatarq=_open will hide the records with HE, but will also hide the records with _open (shouldn't wo show those, not hide them?).....&wolocationdatarq=_open&wnlocationdata=HE will show everything, _open, non-_open, HE and other records.....&wolocationdatarq=_open&wnlocationdata=HE&allreq=T will show all HE records, and all _open records. It will hide the non-_open records for all but the HE's. (if that's clear...)....&wolocationdatarq=_open&nelocationdatarq=HE shows the exact same as above.....&wolocationdatarq=_open&nelocationdata=HE shows the same as above, and interestingly, ignores my sort order and places all the HE170_open to the top, then the rest.Any combinations that I'm missing? I have flushed db's between tries as well. No funky characters in the db either. Any other ideas?I'm assuming that the numbers in the words are giving it the fits. Do I recall a ww search, wordswith perhaps? I don't see it in the docs but will try it now.GK Gary Krockover Webmaster Internet Gateway www.thegateway.net (512) 930-1022 ------------------------------------------------------------- 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/ Gary Krockover

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:

WebCatalog can't find database (1997) Product display (2000) frames & carts (1997) Deleting Orders (1998) [cart] Taxrate - seriously .. (2002) [WebDNA] DNA suffix (2008) ShowIf & CountChars (2000) Limiting user access to .tmpl files (1997) Country & Ship-to address & other fields ? (1997) [HIDEIF] inside [FOUNDITEM] (1997) File Upload (1997) WebMerchant (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Sorting problem (2002) [WebDNA] Does WebDNA run on Ubuntu 16.04? (2016) A little syntax help (1997) Add more fields to an existent data base (1997) Emailer errors (1997) Include a big block of text (1997) [ShowCart]-- was ThankYou page problems (1997)