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 dragwhile the page renders. I had a database of 10,000 email addresses with someshowifs and hideifs looking for common problems (commas, spaces, otherillegal characters) and on a 604/200 it would take 2-4 minutes to run thiscode. I've since redone it as embedded searches for the illegal characters (12total) 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:
>[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 dragwhile the page renders. I had a database of 10,000 email addresses with someshowifs and hideifs looking for common problems (commas, spaces, otherillegal characters) and on a 604/200 it would take 2-4 minutes to run thiscode. I've since redone it as embedded searches for the illegal characters (12total) 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)