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 = 60201
interpreted = N
texte = It will not put undue stress on the server. It's not even doing nested searches, which is something that might actually be considered to put too much stress on the server. This is a very simple one-level search that is doing nothing more than just retrieving all the records, then showing a subset of those records. Everyone does this kind of search with webdna all the time .... without any "undue stress" issues. Sorry to disagree with you Jesse, but this is the way I see it. >To make it clear, using this method will cause undue strain on the >CPU. The better method would be to run a trigger every few hours or >once a day that updated that field with the current values in the >database. Or only change that field when the database itself >changes. > >On Nov 25, 2004, at 6:50 AM, Kenneth Grome wrote: > >> >>[search db=test.db&neFIELDNAMEdatarq=[blank]&other search stuff] >>[founditems] >>[showif [countchars][FIELDNAME][/countchars]<10] > >-- > Jesse Williams-Proudman >Blue Box Development :: Custom Web Solutions > +1 (206) 347-0528 :: jesse@blueboxdev.com -- Sincerely, Kenneth Grome www.kengrome.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)
It will not put undue stress on the server. It's not even doing nested searches, which is something that might actually be considered to put too much stress on the server. This is a very simple one-level search that is doing nothing more than just retrieving all the records, then showing a subset of those records. Everyone does this kind of search with webdna all the time .... without any "undue stress" issues. Sorry to disagree with you Jesse, but this is the way I see it. >To make it clear, using this method will cause undue strain on the >CPU. The better method would be to run a trigger every few hours or >once a day that updated that field with the current values in the >database. Or only change that field when the database itself >changes. > >On Nov 25, 2004, at 6:50 AM, Kenneth Grome wrote: > >> >>[search db=test.db&neFIELDNAMEdatarq=[blank]&other search stuff] >>[founditems] >>[showif [countchars][FIELDNAME][/countchars]<10] > >-- > Jesse Williams-Proudman >Blue Box Development :: Custom Web Solutions > +1 (206) 347-0528 :: jesse@blueboxdev.com -- Sincerely, Kenneth Grome www.kengrome.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:

[listfiles] problems (1997) Great product and great job ! (1997) WC TableGrinder (1997) hideif/showif causes error if wrapped around searches (2003) TCPConnect Help (2003) creating an email message (1998) [Webcat 2]Next (1997) forming a SKU (1999) Likelihood of a duplicate (2005) Re2: frames & carts (1997) Payment Calculator? (2000) Loops N Variables (1998) Searching an Email database (1997) Web Commerce thoughts and needs.. (1996) WARNING: deletedb anomaly (2002) [WebDNA] TLS 1.2 and [tcpconnect] (2018) Criticism of WebCatalog: Keep It Coming! (1998) [Announce]: Web server security and password protection (1997) WCS Newbie question (1997) re: emailer prob (1998)