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:
Help! WebCat2 bug (1997)
WebDNA Solutions ... sorry! (1997)
RE: Languages (1997)
Web Catalog Instability (2000)
POSTing to a secure server ... (2000)
Order not created error (1997)
test (2003)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
EmailFolder Correct Permissions ? (2003)
WebSTAR 2.1 freezes my Mac (1997)
Webcat listserver - WAS - webcat method for waitingspecific amount of time? (2000)
Mozilla/4. and Browser Info.txt (1997)
Generating Options for a Form. (1997)
carriage returns in data (1997)
Problems with [Applescript] (1997)
Searching for (field1 OR field2) AND field3 (2000)
cart (1997)
Summing fields (1997)
Preventing Merchant Settling ? (1997)
talk lists down - email question (2002)