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 = 60203
interpreted = N
texte = 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 Gromewww.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:

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)

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 Gromewww.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/ Kenneth Grome

DOWNLOAD WEBDNA NOW!

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

2004

Top Articles:

Related Readings: