Re: Searching Relational Databases
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55313
interpreted = N
texte = .... guess a workaround would be is to create a WebDNA [table] from the multi .db search and then search and sort on that table to create the HTML table?Just a guess ... hahaha ... : c)MKOn Thursday, January 8, 2004, at 10:23 AM, Justin Carroll wrote:> 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 actual 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=business.db&geskudatarq=0]> [founditems]> [search > db=employee.db&eqbusiness_skudatarq=[sku]][numfound][/search]> [/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/>>Signed: Marc Kaiwi-------------------------------------------------------------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:
.... guess a workaround would be is to create a WebDNA [table] from the multi .db search and then search and sort on that table to create the HTML table?Just a guess ... hahaha ... : c)MKOn Thursday, January 8, 2004, at 10:23 AM, Justin Carroll wrote:> 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 actual 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=business.db&geskudatarq=0]> [founditems]> [search > db=employee.db&eqbusiness_skudatarq=[sku]][numfound][/search]> [/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/>>Signed: Marc Kaiwi-------------------------------------------------------------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/
Marc Kaiwi
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:
Preventing Merchant Settling ? (1997)
Calendar (1997)
SmithMicro FTP problems (2002)
[WebDNA] sem_open bugfix for os x version 6.2 (2012)
Using EIMS instead of Emailer (1998)
Sample Tearoom Search Error (1997)
CSS positioning!!! (2001)
Major Security Hole IIS NT (1998)
[OT] two domains one site... (2005)
my SOS last week... (1996)
RE: IIS4b2 and WebCatalog b19 (1997)
[WebDNA] BBEdit WebDNA codeless language module (2016)
[Cart] ... (1997)
[listfields] on Mac OS w/WC 3.x (2001)
[WebDNA] feature request (2011)
# of real domains on 1 web server (1997)
[BoldWords] WebCat.acgib15Mac (1997)
Time comparison question (1998)
Date Formats (1997)
[CART] inside a [LOOP] (1997)