Multiple database search
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33831
interpreted = N
texte = I have a multiple database search problem I can't figure out.A product is described by up to 6 different codes, and I want to display all the codes from the product database, sorted by a code description that is looked up from a second database.If a product is described by codes S1 to S6: [search db=products.db&group1field=S1+S2+S3+S4+S5+S6>group1data=&group1summ=T&asg roup1sort=1]But I can't lookup the founditems based on group1; what I'd like to do is something like: [founditems]
[lookup db=subjcode.db&value=[group1]&lookinfield=subjcode&returnfield=description] [/founditems]to give me a summarized list of code descriptions sorted by their description.Is there anyway to do this without writing the [founditems] to a temporary database, resorting, and looking them up from there?Thanks in advance,Kevin Lippert------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I have a multiple database search problem I can't figure out.A product is described by up to 6 different codes, and I want to display all the codes from the product database, sorted by a code description that is looked up from a second database.If a product is described by codes S1 to S6: [search db=products.db&group1field=S1+S2+S3+S4+S5+S6>group1data=&group1summ=T&asg roup1sort=1]But I can't lookup the founditems based on group1; what I'd like to do is something like: [founditems] [lookup db=subjcode.db&value=[group1]&lookinfield=subjcode&returnfield=description] [/founditems]to give me a summarized list of code descriptions sorted by their description.Is there anyway to do this without writing the [founditems] to a temporary database, resorting, and looking them up from there?Thanks in advance,Kevin Lippert------------------------------------------------------------- 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://search.smithmicro.com/
Kevin Lippert
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:
Upgrading old WebCat Database Files (1997)
Here we go again... (2006)
Why WebDNA is not popular (2002)
Server slowing down. (1997)
Smart caching problems with 2.1b3? (1997)
OT bookmark my site (1999)
founditem align (1998)
[moveFile] Question (1999)
Search all Fields in a db (1997)
Explorer 3.0 (1997)
unixODBC: WebCatalog patch available for OS X Client/Server (2001)
Exclamation point (1997)
IP Address (2001)
url question (2002)
Multiple Items (1998)
Counting records (2000)
autosensing lanague selection (1997)
carriage returns in data (1997)
Add to a field (1998)
Mozilla/4. and Browser Info.txt (1997)