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) MK On 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) MK On 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:
Browser Resolution (1999)
Yet another db manager (2004)
bug in [SendMail] (1997)
emailer setup (1997)
[WC 2.1.30] Stack overflow. (2000)
Mozilla/4. and Browser Info.txt (1997)
Can't add a field (1998)
access denied problem (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Completed Orders (2006)
beta 2 Plugin (2000)
Random sort is not random at all..... (2000)
Practice runs ? (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Not really WebCat- (1997)
[append] problem (1997)
Help! Missing [showif] or [hideif] (2000)
Signal Raised Error (Part II) (1997)
Part Html part WebDNA (1997)