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 = 60204
interpreted = N
texte = Actually you need the second inside the [showif] that is inside the [founditems] and it should be: [math show=f]theindex=[theindex]+1[/math] .. :) ----- Original Message ----- From: "Kenneth Grome" To: "WebDNA Talk" Sent: Friday, November 26, 2004 7:37 AM Subject: Re: How to search for fields with 10 or more characters? > If you put this immediately above the [founditems] tag: > > [math show=f]theindex=0[/math] > > ... and this immediately below the [founditems] tag: > > [math show=f]theindex=theindex+1[/math] > > ... you can use the tag [theindex] instead of [index] inside your > founditems context to display an index value for each record that looks > "correct" to your visitors. There's more to it than this if you must use > shownext links, but for small data subsets that display on one page this > is a useful work-around to your [index] problem. > > :) > > Sincerely, > Kenneth Grome > www.kengrome.com > > > >>Thanks Ken for providing a workaround. >> >>It helped in this case, although now when I use [index] inside the >>[showif] it shows that I am filtering the results. >> >>If I use [index] outside the [showif] I get blanks. >> >>It would be nice if I could express a search just to return the results I >>want, rather than having to be selective about displaying results. >> >>Anyway it worked, so thanks. >> >>Yours >> >>Phil. >>On 26 Nov 2004, at 05:29, Kenneth Grome wrote: >> >>>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/ ------------------------------------------------------------- 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)
Actually you need the second inside the [showif] that is inside the [founditems] and it should be: [math show=f]theindex=[theindex]+1[/math] .. :) ----- Original Message ----- From: "Kenneth Grome" To: "WebDNA Talk" Sent: Friday, November 26, 2004 7:37 AM Subject: Re: How to search for fields with 10 or more characters? > If you put this immediately above the [founditems] tag: > > [math show=f]theindex=0[/math] > > ... and this immediately below the [founditems] tag: > > [math show=f]theindex=theindex+1[/math] > > ... you can use the tag [theindex] instead of [index] inside your > founditems context to display an index value for each record that looks > "correct" to your visitors. There's more to it than this if you must use > shownext links, but for small data subsets that display on one page this > is a useful work-around to your [index] problem. > > :) > > Sincerely, > Kenneth Grome > www.kengrome.com > > > >>Thanks Ken for providing a workaround. >> >>It helped in this case, although now when I use [index] inside the >>[showif] it shows that I am filtering the results. >> >>If I use [index] outside the [showif] I get blanks. >> >>It would be nice if I could express a search just to return the results I >>want, rather than having to be selective about displaying results. >> >>Anyway it worked, so thanks. >> >>Yours >> >>Phil. >>On 26 Nov 2004, at 05:29, Kenneth Grome wrote: >> >>>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/ ------------------------------------------------------------- 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/ "WebDna @ Inkblot Media"

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:

too many nested [xxx] (1997) Banners (1997) [WebDNA] [PROTECT] - Log Out (2011) Plugin or CGI or both (1997) Database and Log file merged..... (2000) Individual LineItemChangePassword files would be better ... (1999) [include ...] behavior (1997) WebCatalog 2.1 for NT (1998) emailer w/F2 (1997) WebCatalog can't find database (1997) Undeclared variables (2004) Looking for WebDNA calendar (2004) TeaRoom Order fields email account remain empty even though thewy are filled. (1997) Search/sort in URL Was: GuestBook example (1997) Instructions for Digest (1997) Whats going on with my SERIAL NUMBER??? (1998) Single Link browsing (1997) WebDNA Feature Request (2006) Event ticketing code? (2000) Different Tax levels (1998)