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:
WebCat2b15MacPlugin - [protect] (1997)
UPS Shipping Docs (Where To Go) (1999)
Bug or syntax error on my part? (1997)
WebCat2 - Getting to the browser's username/password data (1997)
more on my bbs (1997)
Sorting by multiple fields (2003)
combining strings (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Date Sorting (1997)
on/off values (2000)
Summing fields (1997)
We have Proof (1997)
Hello??? (1997)
WebCatalog 4.0.2b5 install problems (2000)
Satisfy Me ! was: Why can't support be satisfying to (2000)
Working Days - Corrected (2004)
WebCat2 - [SendNews] (1997)
ListFields and [name] (1997)
For those of you not on the WebCatalog Beta... (1997)
RAM variables (1997)