Searching Relational Databases
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55311
interpreted = N
texte = Say I have a business.db and an employee.db. The business.db is a list of = businesses and the employee.db is a list of people who work at the = businesses in the businesses.db. The employee.db has three headers: sku, employee_name, and business_sku. The business.db has three headers: sku, business_name, and business_= address. When viewing the business.db contents on an html page, I put in an extra = header in my table called Employees but keep in mind that there is no actua= l Employees header in the business.db. What goes in this Employess column = is the number of employees that the particular business has working there. = I pull this information by doing a [search] on the employee.db and = pulling the [numfound] of employee_name I get in return by sending it the = business.db current sku. Here's an example: [search db=3Dbusiness.db&geskudatarq=3D0] [founditems] [search db=3Demployee.db&eqbusiness_skudatarq=3D[sku]][numfound][/searc= h] [/founditems] [/search] Here's my problem: All the headers for the business.db html data table are clickable so that = the user can sort by them. I haven't done this for the Employees header = yet because I can't figure out how to search the employee.db and then sort = the business.db contents based on the returned data. Hopefully I communicated my problem well enough. This is a fictional = situation but the core problem is what I'm after -- how to search another = db inside of a search and affect the parent search results. Any help = would be greatly appreciated. Thank you. Justin Carroll ------------------------------------------------------------- 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:
Say I have a business.db and an employee.db. The business.db is a list of = businesses and the employee.db is a list of people who work at the = businesses in the businesses.db. The employee.db has three headers: sku, employee_name, and business_sku. The business.db has three headers: sku, business_name, and business_= address. When viewing the business.db contents on an html page, I put in an extra = header in my table called Employees but keep in mind that there is no actua= l Employees header in the business.db. What goes in this Employess column = is the number of employees that the particular business has working there. = I pull this information by doing a [search] on the employee.db and = pulling the [numfound] of employee_name I get in return by sending it the = business.db current sku. Here's an example: [search db=3Dbusiness.db&geskudatarq=3D0] [founditems] [search db=3Demployee.db&eqbusiness_skudatarq=3D[sku]][numfound][/searc= h] [/founditems] [/search] Here's my problem: All the headers for the business.db html data table are clickable so that = the user can sort by them. I haven't done this for the Employees header = yet because I can't figure out how to search the employee.db and then sort = the business.db contents based on the returned data. Hopefully I communicated my problem well enough. This is a fictional = situation but the core problem is what I'm after -- how to search another = db inside of a search and affect the parent search results. Any help = would be greatly appreciated. Thank you. Justin Carroll ------------------------------------------------------------- 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/
Justin Carroll
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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Math Hell! (2000)
New public beta available (1997)
Can I invoke an ssi plugin from within a webcat page (1997)
Beta 18 (1997)
carriage returns in data (1997)
[WebDNA] WebDNA on Linux (2009)
hidden databases (2000)
Newbie questions (2000)
multiple search commands (1997)
Banners (1997)
Eudora Plugin (1999)
Document Contains no data, or showcart error. (1997)
Silence before the storm? (2004)
2.0 Info (1997)
[include] and not found (2005)
[WriteFile] problems (1997)
Appending Information from one db to another (1998)
Reversed words (1997)
Date search bug (1998)