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:

Giving out error pages (1997) Calculating multiple shipping... (1997) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) WebCatalog.acgi quitting with error Type 2 (1998) proper username/password *w/out* the authenticate dialog. (2000) 2nd WebCatalog2 Feature Request (1996) More EudoraPro Email Options (1998) command line in webDNA 5?! (2003) Re[3]: Weird [blank] interpretation (1999) WebCat2 - [include] tags (1997) Counting files (1998) how to determine the actual file format of an image file? (2002) Sorry, the WebDNA engine has reached its connection limit. (2002) Sort Order on a page search (1997) WebCat2b12--[searchstring] bug (1997) Email...Thanks (1997) f2 download problems (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Transfering [text] variables (2000) TCPConnect to query for Domain expiration (2000)