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 = 60207
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Brian Fries
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:
WebCat2b15MacPlugin - [protect] (1997)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
[WebDNA] Encrypted password issue (2009)
WC on Mac OS X or Mac OS X Server 2.x (2001)
Multiple cart additions (1997)
NetForms for email (1998)
6.0 Serial - Moving to New Server (2004)
Large databases in WebCat (1997)
WebCat2 beta 11 - new prefs ... (1997)
[WebDNA] Website almost dead? (2016)
CSV import suggestions (2007)
[HTML*] (a proposition) (1997)
Problems reading files created by WC (1997)
AccountAuthorizer doesn't seem to work (1997)
$Quit, $CloseDatabase corrections (1997)
too many nested tags ... (1997)
Country & Ship-to address & other fields ? (1997)
country of origin from IPADDRESS??? (2001)
2nd WebCatalog2 Feature Request (1996)
delete a file? (1998)