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:
problems with 2 tags shakur (1997)
help needed: Non-english characters in WebCatalog (1997)
re: WebCat 3.0 (1998)
Spreadsheet Interface. (1998)
[OT] MacOs IE5 topmargin and leftmargin bug (2000)
[WebDNA] Good advise on [Showif] or alternative... (2012)
Summing fields (1997)
Include a big block of text (1997)
A Suggestion? (1998)
math problems (2000)
Just a thought (1998)
Multi Actions (1999)
Exclamation point (1997)
drop down selection list for a search (1998)
Can this be done? (1997)
displaying New products (Yikes! it's Fixed!) (1997)
[WebDNA] listfiles weirdness? (2018)
Only charge card when product shipped ? (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Problems with [Applescript] (1997)