Re: How to search for fields with 10 or more characters?

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 60199
interpreted = N
texte = From your description it seems you may want a search that returns all the RECORDS that have more than 10 characters in a specified field. If this is what you want, you must retrieve all the records in the database (or the subset that you're actually looking for) then use countchars on the field you're checking, like this: [search db=test.db&neFIELDNAMEdatarq=[blank]&other search stuff] [founditems] [showif [countchars][FIELDNAME][/countchars]<10] These are the records with more than 10 chars in the FIELDNAME field that also match your other search parameters ... [/showif] [/founditems] [/search] Sincerely, Kenneth Grome www.kengrome.com >Hello. > >I am trying to express a search that returns all fields with more >than 10 characters. > >How would I do this? > >something like > >[search db=test.db&geFIELDNAMElengthrq=10&other search stuff] > >I could add a database field for length, but would prefer to express >a search that can work with existing dbs. > >Yours > >Philip Edell > > >------------------------------------------------------------- >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: How to search for fields with 10 or more characters? ( "WebDna @ Inkblot Media" 2004)
  2. Re: How to search for fields with 10 or more characters? ( Brian Fries 2004)
  3. Re: How to search for fields with 10 or more characters? ( "WebDna @ Inkblot Media" 2004)
  4. Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
  5. Re: How to search for fields with 10 or more characters? ( "WebDna @ Inkblot Media" 2004)
  6. Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
  7. Re: How to search for fields with 10 or more characters? ( Philip Edell 2004)
  8. Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
  9. Re: How to search for fields with 10 or more characters? ( Jesse Proudman 2004)
  10. Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
  11. How to search for fields with 10 or more characters? ( Philip Edell 2004)
From your description it seems you may want a search that returns all the RECORDS that have more than 10 characters in a specified field. If this is what you want, you must retrieve all the records in the database (or the subset that you're actually looking for) then use countchars on the field you're checking, like this: [search db=test.db&neFIELDNAMEdatarq=[blank]&other search stuff] [founditems] [showif [countchars][FIELDNAME][/countchars]<10] These are the records with more than 10 chars in the FIELDNAME field that also match your other search parameters ... [/showif] [/founditems] [/search] Sincerely, Kenneth Grome www.kengrome.com >Hello. > >I am trying to express a search that returns all fields with more >than 10 characters. > >How would I do this? > >something like > >[search db=test.db&geFIELDNAMElengthrq=10&other search stuff] > >I could add a database field for length, but would prefer to express >a search that can work with existing dbs. > >Yours > >Philip Edell > > >------------------------------------------------------------- >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/ 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:

Email (1998) problems with 2 tags (1997) Re[4]: Problem with new formvariables (2000) Summing fields (1997) Associative lookup style? + bit more (1997) Error Template (1999) Weird Math (2000) [SearchString] problem with [search] context (1997) Fun with dates (1997) NewCart+Search with one click ? (1997) [WebDNA] Digest from talk@webdna.us (2015) WebCatalog + Linux + ODBC + Oracle ! ? (2000) [tcpsend] (2001) Security for malls with different webmasters (1998) OT: Urgent help with Windows and Javascript (2003) RE: Sum of Quantities (1997) WebDNA 5.0 freeBSD?!!? (2003) Sample Tearoom Search Error (1997) template includes encrypted template (1999) Bad merge format error message. (2004)