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&asgroup1sort=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&asgroup1sort=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:
For those of you not on the WebCatalog Beta... (1997)
[WebDNA] Require no empty field (2010)
WebCat on Apache (2002)
Separate SSL Server (1997)
Migrating to NT (1997)
more on quicktime test stuff (1997)
WebCat b13 CGI -shownext- (1997)
PCS Frames (1997)
Sorry I didn't pay attention-but ??? (1997)
No. of items in shopping cart (2000)
Problems setting MIME Headers (1998)
[WebDNA] Sendmail 'return-path' header that is different to the 'from' header (2009)
HTTP upload (2000)
Answer: WebDelivery downloads alias, not original ? (1997)
[OT] FTP client (2003)
Three new problems, maybe a fourth (1997)
Selected Item in Pop-down (2003)
WebCatalog f2 Installation (1997)
includes and cart numbers (1997)
Webcat causing crashes left and right! (1997)