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:
WebCatalog (1999)
Open Databases on Restart (1999)
Same Database needed on two machines (2002)
sort problems....bug or brain fart? (1997)
Rotating photo gallery (2004)
Feature Request: [moverecord] (2003)
Table code broken? (2004)
[WebDNA] Google map mashups (2010)
ListFields and [name] (1997)
Store Builder Weirdness (1999)
[WriteFile] problems (1997)
cannot delete last admin (1999)
How to download a database???/ (2000)
WebStar Secure on other machine (1997)
Satistics (1999)
Loop weirdness (2003)
RE: Fishing: anyone on this group willing to do support? (1998)
[SHELL] SSH more problems (2003)
Bulk Linebreak Changes (2002)
ReadDateFormat (1998)