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 = 60206
interpreted = N
texte = Learn something new everyday. :) ----- Original Message ----- From: "Kenneth Grome" To: "WebDNA Talk" Sent: Friday, November 26, 2004 9:21 AM Subject: Re: How to search for fields with 10 or more characters? > You're right about the second math context needing to be inside the > showif, but not about the brackets around the second "theindex" string. > > The brackets are only needed when the variable "theindex" is a text > variable, but in this case it is a math variable, which means the brackets > are 'assumed' by the fact that it appears inside a math context. > > Try it, you'll see that it works without the brackets when "theindex" is a > math variable, but it won't work without the brackets when "theindex" is a > text variable! > > :) > > Sincerely, > Kenneth Grome > www.kengrome.com > > > > > >>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/ > > > -- > > ------------------------------------------------------------- > 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)
Learn something new everyday. :) ----- Original Message ----- From: "Kenneth Grome" To: "WebDNA Talk" Sent: Friday, November 26, 2004 9:21 AM Subject: Re: How to search for fields with 10 or more characters? > You're right about the second math context needing to be inside the > showif, but not about the brackets around the second "theindex" string. > > The brackets are only needed when the variable "theindex" is a text > variable, but in this case it is a math variable, which means the brackets > are 'assumed' by the fact that it appears inside a math context. > > Try it, you'll see that it works without the brackets when "theindex" is a > math variable, but it won't work without the brackets when "theindex" is a > text variable! > > :) > > Sincerely, > Kenneth Grome > www.kengrome.com > > > > > >>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/ > > > -- > > ------------------------------------------------------------- > 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:

[ot] G5 Desktop as Server (2004) authorizenet and netscape (2002) [getchars] questions (1997) Banners and sort of random display (1997) OT. Self explanatory (2003) Somewhat OT: IE issues (2002) Speed/performance issues using .hdr (1997) WC2/Mac -- Forms not submitting correctly with Mac browsers (1997) For Sale (2): WebTen 3.x (!) and WebCat 2.x (2000) Separate SSL Server (1997) WebDNA 5.0 Enterprise Edition (2003) WebMerchant %s error using Authorize.Net (2000) autosensing lanague selection (1997) Works! (1997) Restart of DBserver (1997) rn doesn't work on date fields (1998) WCS Newbie question (1997) [WriteFile] problems (1997) Emailer (1997) Can't Update records (1997)