Re: build a select list from a db search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 60414
interpreted = N
texte = I think you are looking for the unique IDs in your database. There is a way to do this in the search.Add &IDsumm=T to your search and get rid of the HIDEIF you're using. That should speed things up. I'm not sure why you're using HOWMANY. [NUMFOUND] tells you how many records are returned by the search.Bill-----Original Message-----From: Marc Thompson
Sent: Thu, 09 Dec 2004 15:48:15 -0700To: "WebDNA Talk" Subject: build a select list from a db searchIs 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 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/-------------------------------------------------------------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 think you are looking for the unique IDs in your database. There is a way to do this in the search.Add &IDsumm=T to your search and get rid of the HIDEIF you're using. That should speed things up. I'm not sure why you're using HOWMANY. [NUMFOUND] tells you how many records are returned by the search.Bill-----Original Message-----From: Marc Thompson Sent: Thu, 09 Dec 2004 15:48:15 -0700To: "WebDNA Talk" Subject: build a select list from a db searchIs 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 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/-------------------------------------------------------------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/
devaulw@onebox.com
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:
[OT] Multi - Language (2007)
OT: Please set your computer's clock (1997)
Yet another db manager (2004)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
The Box - (2003)
Stopping bad HTML propagation ? (1997)
UPDATE PROBLEM (1997)
orders being printed (1998)
DON'T use old cart file! (1997)
How do you TEAM Code? (2004)
Globals Permissions (2003)
suffix mapping for NT? (1997)
HELP WITH DATES (1997)
Individual Tax on Items (1998)
I am sorry for always being such an ass (2004)
Searching multiple Databases (1997)
WebCat2 Append problem (B14Macacgi) (1997)
unsubscribe (1997)
WebDelivery downloads alias, not original ? (1996)
Bad Cookie / Internet Option / Internet Explorer (2004)