Re: build a select list from a db search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60410
interpreted = N
texte = Thanks Brian,That was a piece of code I wrote several years ago. Apparently at the time, and even now for that matter, I'd forgotten about "FieldNamesumm=T".Many thanks!MarcBrian Fries wrote:> 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.> > - brian> > On 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/> > -- -------------------------------------------Marc ThompsonSoftware EngineerOffice of Information TechnologyUniversity of Utah801.585.9264marc.thompson@utah.edu--------------------------------------------------------------------------------------------------------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:
Thanks Brian,That was a piece of code I wrote several years ago. Apparently at the time, and even now for that matter, I'd forgotten about "FieldNamesumm=T".Many thanks!MarcBrian Fries wrote:> 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.> > - brian> > On 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/> > -- -------------------------------------------Marc ThompsonSoftware EngineerOffice of Information TechnologyUniversity of Utah801.585.9264marc.thompson@utah.edu--------------------------------------------------------------------------------------------------------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/
Marc Thompson
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:
Snake Bites (1997)
WebDNA-Talk Digest mode broken (1997)
DON'T use old cart file! (1997)
Math Bug (1999)
Changes to the List (1997)
suffix mapping, use of cache, etc. (1997)
Moving records (2000)
Catalogs and W* (1996)
transferring values (1998)
Buying sans cart (1997)
Who owns the code? (2002)
Problem (1997)
GuestBook example (1997)
[shownext] and sort (1998)
Navigator 4.0 & tables (1997)
WCS Newbie question (1997)
Server Creation - vendors (2005)
2nd WebCatalog2 Feature Request (1996)
help (2003)
emailer suddenly stops (1998)