Re: a search based on ^(contains)

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21639
interpreted = N
texte = >[search db=xxx.db&neskudatarq=[blank]] >[founditems] >[hideif [sku]^.] > >SKU = [sku]
> >[/hideif] >[/founditems] >[/search]If your database is large, this simple hideif loop will cause a HUGE drag while the page renders. I had a database of 10,000 email addresses with some showifs and hideifs looking for common problems (commas, spaces, other illegal characters) and on a 604/200 it would take 2-4 minutes to run this code. I've since redone it as embedded searches for the illegal characters (12 total) that runs in about 1.5 seconds. (20K records) Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer? I am today. Associated Messages, from the most recent to the oldest:

    
  1. Re: a search based on ^(contains) (Brian B. Burton 1998)
  2. Re: a search based on ^(contains) (Kenneth Grome 1998)
  3. Re: a search based on ^(contains) (Tim Taylor 1998)
  4. Re: a search based on ^(contains) (PCS Technical Support 1998)
  5. Re: a search based on ^(contains) (Tim Taylor 1998)
  6. Re: a search based on ^(contains) (Martin Gertz Bech 1998)
  7. a search based on ^(contains) (Tim Taylor 1998)
>[search db=xxx.db&neskudatarq=[blank]] >[founditems] >[hideif [sku]^.] > >SKU = [sku]
> >[/hideif] >[/founditems] >[/search]If your database is large, this simple hideif loop will cause a HUGE drag while the page renders. I had a database of 10,000 email addresses with some showifs and hideifs looking for common problems (commas, spaces, other illegal characters) and on a 604/200 it would take 2-4 minutes to run this code. I've since redone it as embedded searches for the illegal characters (12 total) that runs in about 1.5 seconds. (20K records) Brian B. Burton BOFH - Department of Redundancy Department --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.comAre you a Web Programmer? I am today. Brian B. Burton

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:

[WebDNA] [ReturnRaw] problem (2010) writing cart to db (1998) Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= (2004) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) Help! WebCat2 bug (1997) (1997) Languages (1997) OT: SMSI stock (2003) frames & carts (1997) PCS Emailer's role ? (1997) Archives are missing (2003) Up and running ... at last !! (1997) [WebDNA] Installation on windows 2008 server (2010) [ModDate] & [ModTime] ? (1997) WebCat2 - Getting to the browser's username/password data (1997) [WriteFile] problems (1997) template includes encrypted template (1999) Another question (1997) WebCat2: Items xx to xx shown, etc. (1997) Checkboxes (1998)