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 = 60204
interpreted = N
texte = 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 AMSubject: 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:
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 AMSubject: 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:
New Site Announcement (1998)
WC2f3 (1997)
database problem (2003)
Formvariables + Netscape + Frame Set = Confusion (2000)
Dismissing dialogs (was 2.1b3 --> way slow) (1997)
lazy programming (2000)
[WebDNA] two ideas for running a cluster of WebDNA servers (2019)
Error in searchable archives (2002)
Getting total number of items ordered (1997)
Data Variables partially show up (1998)
Locking up with WebCatalog... (1997)
[OT] Airport Network (2003)
Secure server question (1997)
Nested tags count question (1997)
Line Feed problems ... (2002)
[ShowNext] feature in 2.0 (1997)
PhotoMill -> PhotoMaster (1997)
Help formatting search results w/ table (1997)
Mac carriage returns (2004)
all records returned. (1997)