Re: build a select list from a db search
This WebDNA talk-list message is from 2004
numero = 60409
interpreted = N
texte = Maybe [search db=_receipts.db&geSKUdatarq=0&IDsumm=t&Deptsort=1] [founditems]
[Dept] [/founditems] [/search] That will build a list of the unique ID's in your db. Is that what you want? So you can do away with the text you are cecking to see if you've already sown an ID. You can do away with the hideif, cuz the search will only find non-blank results. You can do away with the math, cuz numfound will be correct. I'm not positive I see what you are trying to do. On 12/9/04 2:48 PM, Marc Thompson mashed the following keys : > 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 > -- ------------------------------------------------------------- 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:[founditems] [Dept] [/founditems] [/search] That will build a list of the unique ID's in your db. Is that what you want? So you can do away with the text you are cecking to see if you've already sown an ID. You can do away with the hideif, cuz the search will only find non-blank results. You can do away with the math, cuz numfound will be correct. I'm not positive I see what you are trying to do. On 12/9/04 2:48 PM, Marc Thompson mashed the following keys : > 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 > -- ------------------------------------------------------------- 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/
Aaron Lynch
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-Talk Digests (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Pop-up menu (1998) WC1.6 to WC2 date formatting (1997) [WebDNA] [OT] - One Man. One Road. (2009) Max Record length restated as maybe bug (1997) Search in 2 or more catalogs (1997) Listserver problem (1997) Re:Help name our technology! (1997) Setting up WebCatalog with Retail Pro data (1996) (2000) how to construct a search for not this entire string? (2000) .htm file tags not showing up (2000) InternetWeek E-Commerce article (1998) New Command prefs ... (1997) tcpconnect/tcpsend frustrations (2002) Can WebCatalog.debug solve my problem? (2000) WebCommerce: Folder organization ? (1997) using showpage and showcart commands (1996) Cannot open database (1999)