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:
SiteEdit Pro Update Announcement (1997)
Speed questions (1998)
Using a database with a short url (2000)
[defined]ish (1997)
two unique banners on one page (1997)
Emailer port change (1997)
MacOS9 plugin 4.0.2b5 template security error (2000)
Accepting credit cards (1997)
a search based on ^(contains) (1998)
Xserve Recommendations (2003)
Emailer port change (1997)
Webmerchant confirmation hooks? (1997)
OT- AS/400 and Macs (2003)
Fwd: Handling Charges (1999)
File not found error message (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[REFERRER] works with form posts (2003)
Suffix Slowdown? (2004)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
PIXO Support (1997)