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 = 60202
interpreted = N
texte = 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.YoursPhil.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)

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.YoursPhil.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/ Philip Edell

DOWNLOAD WEBDNA NOW!

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

2004

Top Articles:

Related Readings: