Re: build a select list from a db search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60408
interpreted = N
texte = If I'm reading your intent right, you should be using "&IDsumm=T" in your search so you only find one record with each ID value.- brianOn Dec 9, 2004, at 2:48 PM, Marc Thompson wrote:> Is there a better, more efficient way to build a
list than > the example I have below. The _receipts.db contains over 24,000 > records. Seems like this a starting to take too long to build?>> [Text]Found_ID=[/Text]> [math show=f]howmany=1-1[/math]> > [search db=_receipts.db&neSKUdatarq=find_all&Deptsort=1]> [founditems]>> [HideIf [Found_ID]^[ID]]> [math show=f]howmany=[howmany]+1[/math]> [Dept] > [/HideIf]>> [Text]Found_ID=[Found_ID],[ID][/Text]>> [/founditems]> [/search]> >> Marc> -- > -------------------------------------------> Marc Thompson> Software Engineer> Office of Information Technology> University of Utah> 801.585.9264> marc.thompson@utah.edu> ------------------------------------------->-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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:
If I'm reading your intent right, you should be using "&IDsumm=T" in your search so you only find one record with each ID value.- brianOn Dec 9, 2004, at 2:48 PM, Marc Thompson wrote:> Is there a better, more efficient way to build a list than > the example I have below. The _receipts.db contains over 24,000 > records. Seems like this a starting to take too long to build?>> [text] Found_ID=[/Text]> [math show=f]howmany=1-1[/math]> > [search db=_receipts.db&neSKUdatarq=find_all&Deptsort=1]> [founditems] >> [HideIf [Found_ID]^[ID]]> [math show=f]howmany=[howmany]+1[/math]> [Dept] > [/HideIf]>> [text] Found_ID=[Found_ID],[ID][/Text]>> [/founditems]> [/search]> >> Marc> -- > -------------------------------------------> Marc Thompson> Software Engineer> Office of Information Technology> University of Utah> 801.585.9264> marc.thompson@utah.edu> ------------------------------------------->-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/
Brian Fries
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:
Credit Card Number checking (1997)
New Plug-in and Type 11 errors (1997)
Nutscrape Doesn't Render Right (2002)
[Announce] WebCatalog 3.0 Beta Program (1998)
same bill to and ship to? (1998)
[WriteFile] problems (1997)
[WebDNA] 8.0.2 Install on Yosemite Fails (2015)
[SendMail] from a form? (1998)
searchable list archive (1997)
catagories (1997)
serial number generation (1997)
Can you do this??? and other stuff (1997)
Still Stumped on ShowNext...HELP! (1997)
Execute Applescript (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
WebCat2b12 - New features for 1.6 users ... (1997)
dates and hex formatting (1997)
unique ascending numbers (2003)
WebCat Beta NT 18 (1997)
Setting up shop (1997)