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 = 60205
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
[WebDNA] encrypt files/directories (2011)
HELP-1!!! (1998)
Zip Code Search (2000)
RAM variables (1997)
WC TableGrinder (1997)
Sendmail truncation in Eudora Clients (1998)
CSV? (2000)
webmerch and serials - almost there (1997)
Retrieve deleted files (2001)
Globals folders (2004)
Emailer Set Up (1997)
NT or Mac (1997)
Include a big block of text (1997)
Modifying order output (1997)
Format question WC Mac f3 (1997)
Navigator 4.01 (1997)
ShippingCosts (1998)
Emailer (WebCat2) (1997)
WebCat2.0 [format thousands .0f] no go (1997)
My solution... (1996)