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 = 60208
interpreted = N
texte = lol ... never said it was not an OLD tool, just that in my many years of developing webcat I have not used it. Thus the word LEARN in there. =) ----- Original Message ----- From: "Brian Fries"
To: "WebDNA Talk" Sent: Friday, November 26, 2004 10:21 AM Subject: Re: How to search for fields with 10 or more characters? > Actually, that's something OLD.... Before WabCatalog 3.0 (if i remember > rightly) there was no text context, and the only way to view a math > variable was with [math]varname[/math]... Ken is dating himself (as am I > ;) > > - Brian > > On Nov 26, 2004, at 10:07 AM, WebDna @ Inkblot Media wrote: > >> 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/
Associated Messages, from the most recent to the oldest:
lol ... never said it was not an OLD tool, just that in my many years of developing webcat I have not used it. Thus the word LEARN in there. =) ----- Original Message ----- From: "Brian Fries" To: "WebDNA Talk" Sent: Friday, November 26, 2004 10:21 AM Subject: Re: How to search for fields with 10 or more characters? > Actually, that's something OLD.... Before WabCatalog 3.0 (if i remember > rightly) there was no text context, and the only way to view a math > variable was with [math]varname[/math]... Ken is dating himself (as am I > ;) > > - Brian > > On Nov 26, 2004, at 10:07 AM, WebDna @ Inkblot Media wrote: > >> 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/
"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:
Tip for making barcharts (1997)
Serving images from databases (1998)
variables in [addlineitem] (1998)
[WebDNA] Crashing again (2008)
Cart date/time (2006)
Did you hear about this? (1997)
New install permissions (2003)
Error:Too many nested [xxx] contexts (1997)
Code database (1998)
SV: Mass Mail (2000)
Verifying and adding new users (1997)
BGcolor (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[showif [math (1999)
transferring values (1998)
Date format problems (1997)
3.08 installer (2003)
db merge problem (2002)
Some ThankYou page problems (1997)
attacment pdf (2001)