Re: build a select list from a db search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60413
interpreted = N
texte = I was doing this for a client a long time ago, until she told me she didn't want the select list anyways. Her staff already knew the order numbers they wanted to review, so they preferred a text field that they could type the number into ... :)>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>------------------------------------------->>------------------------------------------------------------->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/-- Sincerely,Kenneth Gromewww.kengrome.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:
I was doing this for a client a long time ago, until she told me she didn't want the select list anyways. Her staff already knew the order numbers they wanted to review, so they preferred a text field that they could type the number into ... :)>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>------------------------------------------->>------------------------------------------------------------->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/-- Sincerely,Kenneth Gromewww.kengrome.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/
Kenneth Grome
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:
Further tests with the infamous shipCost (1997)
Tracking E-mail click thrus (2001)
The Top Ten (2002)
Login and pass variables to [protect] tag (2001)
WebCatalog Hosting (1996)
Trouble with formula.db + more explanation (1997)
(2000)
Practice runs ? (1997)
Running a store on BOTH http and https (1998)
And/or Search (1998)
Time comparison question (1998)
Everyone: List Traffic (was [include ...] behavior) (1997)
Webcat run amuk (2002)
Rendering out a page-test results (1997)
WebDNA-Talk Digest mode broken (1997)
Error.html (1997)
Emails are Stuck (2003)
Appending Record Prob (2001)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Triggers Suck! (2000)