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 AMSubject: 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:

Re: How to search for fields with 10 or more characters? ( "WebDna @ Inkblot Media" 2004)
Re: How to search for fields with 10 or more characters? ( Brian Fries 2004)
Re: How to search for fields with 10 or more characters? ( "WebDna @ Inkblot Media" 2004)
Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
Re: How to search for fields with 10 or more characters? ( "WebDna @ Inkblot Media" 2004)
Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
Re: How to search for fields with 10 or more characters? ( Philip Edell 2004)
Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
Re: How to search for fields with 10 or more characters? ( Jesse Proudman 2004)
Re: How to search for fields with 10 or more characters? ( Kenneth Grome 2004)
How to search for fields with 10 or more characters? ( Philip Edell 2004)

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 AMSubject: 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!

Re: How to search for fields with 10 or more characters?

2004

Top Articles:

Related Readings: