Re: Searching two databases
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38354
interpreted = N
texte = Phil Herring wrote: > > Has anyone figured out a way to simultaneously search two databases, and > combine the results in one [founditems] context? > > I know I can search one db within another, as in: > > [search db=1.db&eqndata=x][founditems] > [search db=2.db&eqskudata=[sku]][founditems] > > (html) > > [/founditems][/search] > [/founditems][/search] > > ...but this is not what I need. I'm trying to integrate matches in one > sort, from two db's. > > Is this possible?? > Short answer: noSlightly longer answer: use temporary databaseWebCat is not by nature a relational database, so you cannot join two tables and have the records appear in a single [founditems] context. Of course, you can store your data in an external relational database and do what you want there.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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:
Phil Herring wrote: > > Has anyone figured out a way to simultaneously search two databases, and > combine the results in one [founditems] context? > > I know I can search one db within another, as in: > > [search db=1.db&eqndata=x][founditems] > [search db=2.db&eqskudata=[sku]][founditems] > > (html) > > [/founditems][/search] > [/founditems][/search] > > ...but this is not what I need. I'm trying to integrate matches in one > sort, from two db's. > > Is this possible?? > Short answer: noSlightly longer answer: use temporary databaseWebCat is not by nature a relational database, so you cannot join two tables and have the records appear in a single [founditems] context. Of course, you can store your data in an external relational database and do what you want there.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- 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/
John Peacock
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:
WebCat2b12--[searchstring] bug (1997)
Olin (1998)
Running a store on BOTH http and https (1998)
2.0 Info (1997)
WebCat for Unix?? (1997)
a * question (2003)
Order not created error (1997)
WebCatalog [FoundItems] Problem - LONG - (1997)
form data submission gets truncated (1997)
orderfile headers (was: 2nd Request for help/adviceonvariable pricing) (2000)
[closeDataBase myDataBase.db] not working? (1997)
How to include weather (2000)
Loops N Variables (1998)
[WebDNA] listcookie options (2011)
Email Formatting (2001)
REPOST: WebCat & WebSTAR V (2002)
RE: Migrating to NT (1997)
date tag not interpreted (2000)
WebCat2.0 [format thousands .0f] no go (1997)
Update quantity (2000)